Rows not in a table

 Hi!
What is the best way of getting all the rows not in a table? I've got three tables. One table holds SOME of the possible combination of the other two. Now I have to find out witch combinations not in the other two. The only i got working is to take ALL posslble combination MINUS the one in the table but it seems like its slow to do the (almost) same query twice. Are there any better way to sovle this problem??

Thanks in advance
Roland Carsson

--
Roland Carlsson
Jönköping
Sweden


Sent via Deja.com http://www.deja.com/
Before you buy.