Hi Chris you sould use
FULL OUTER JOIN this will give you what you want
>I have two tables. The first of which have all roles availale the next have roles granted to a particular user. How do i select the rows that do not match.
>
>Access acheives this by using the left outer join. I have tried the same technique in Visual Foxpro 6 and SQLSERVER 7 and it does not work. Any ideas ???
>
>Chris
Alexandre Palma
Senior Application Architect