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