On Sat, 10 Nov 2001, Brian wrote:
>
> I am trying to query table1, selecting records that do NOT have a relation in a subset from table3 that is related to
table2.
I tried, but couldn't figure it out.
I think the solutions is along these lines:
-Make a query which will return the combination of all names and tricks.
Something like "select tricks.trick, names,name from tricks,names;"
-Store the result of the query above into a table
-Do an outer join of tricks and the "complete" table for the instances
where the name is null.