Not in (!=) table link

treckor · March 3rd, 2010, 03:34 PM

I need to report all those tables not in another table by the sample number. I tried != in the link setup several different ways, no luck.

PeterPeiGuo · March 4th, 2010, 11:03 AM

Use not exists with subquery, for example:

Code:

SELECT foo, bar FROM t1 WHERE NOT EXISTS (SELECT 1 FROM t2 where t1.samplenumber = t2.samplenumber);

treckor · March 4th, 2010, 02:23 PM

I ended up doing this in a view. I wanted to try to do this in the table link setup using the "!=" option in the link.