What's wrong with this syntax? - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

What's wrong with this syntax?

aznwildkataznwildkat Posts: 139Member
This is in MS Access 2000
SELECT a.*, b.[Position Code], c.[Skill Code]
FROM (Roster AS a RIGHT JOIN [Roster Position] AS b ON a.[Roster ID]=b.[Roster ID] ) right join [Roster Skill] as c on a.[Roster ID] = c.[Roster ID];

What I'm trying to do is to combine 3 tables. I want to include the records that also don't match my criteria. That is why I'm trying to outer join the two tables.

Comments

  • zeeshanzeeshan Posts: 22Member
    : This is in MS Access 2000
    : SELECT a.*, b.[Position Code], c.[Skill Code]
    : FROM (Roster AS a RIGHT JOIN [Roster Position] AS b ON a.[Roster ID]=b.[Roster ID] ) right join [Roster Skill] as c on a.[Roster ID] = c.[Roster ID];
    :
    : What I'm trying to do is to combine 3 tables. I want to include the records that also don't match my criteria. That is why I'm trying to outer join the two tables.
    :
    :

    =======
    Maybe it's ur mistake ...

    SELECT a.*, b.[Position Code], c.[Skill Code]
    FROM (Roster AS [b][blue] a [/blue][/b] RIGHT JOIN [Roster Position] AS b ON a.[Roster ID]=b.[Roster ID] ) right join [Roster Skill] as c on a.[Roster ID] = c.[Roster ID];


    [blue][b]Zeeshan Arshad[/b][/blue]
    [red]Web Developer[/red]
    [green]http://zeeshan.smashglobal.com/[green]

Sign In or Register to comment.