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.

: 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 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];


Zeeshan Arshad
Web Developer
http://zeeshan.smashglobal.com/