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.