I think what you want is something like:
SELEcT * FROM AllRoles WHERE role NOT IN (SELECT role FROM UserRoles)

>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