Page 1 of 1

database join

Posted: Fri Jan 30, 2004 5:49 pm
by vijayanand16
two tables are realted by the column id in each of the tables.I want to select only rows from A that are not in table B.How?

Posted: Fri Jan 30, 2004 6:08 pm
by Unipus
SELECT [fields] FROM table1 LEFT JOIN table2 ON table1.id = table2.id

filter from there.

Posted: Fri Jan 30, 2004 11:38 pm
by McGruff
Can't remember exactly if this is in here but it's always worth a read anyway.

PS: this is a database topic.