Whats Wrong here?

[Kunax]

Hello There

Whats wrong in this query?:

$query = "SELECT FROM xxx_tlf_liste WHERE NOT EXISTS (SELECT FROM xxx_tlf_relations WHERE xxx_tlf_relations.tlfid = xxx_tlf_liste.id)

I would like to get all row from xxx_tlf_liste where the id does not exist in xxx_tlf_relations

Thanks

[Kunax]

hehe good one. t1.tlfid != t2.id will output every instance where the 2 id are different with tables that have above 200 rows thats quite alot

[xblue]

would a left join be what you are looking for?

SELECT table1.* FROM table1
LEFT JOIN table2 ON table1.id=table2.id
WHERE table2.id IS NULL

[Kunax]

yep thats mre like it, thanks