From: rarahim75 on
Hi, i have two similar tables a and b about people. Both tables have
two id columns, say id1 and id2. Either id column can be NULL but not
both.

So what i want to do is..i want to find those people in table a that
dont exist in table b by comparing either one of the two id columns.
How can i achieve this? i tried to do all sorts of JOINs but still not
getting it right.

Please help. Thanks.