[ale] Embartassingly Rusty with SQL

Bob Kruger bkruger at mindspring.com
Mon Mar 24 19:46:44 EDT 2008


All;

Its been a while since I did any serious SQL coding, and I am hitting the wall on a simple problem.

Given two tables (Table 1, Table 2), each with the fields lastname, firstname, how do I do a listing of the tuples in Table 1 that do not contain the same lastname and firtname in Table 2?

I know its fairly easy, I am just missing something.

Thanks in advance for any hints

V/r

Bob




More information about the Ale mailing list