I have three tables table1, table2 and a relation (* <-> *) btween the two - table3.
to select rows from table1 i have:
How do I negate the result? Getting all rows that don't have an entry in table3 for table2ID = 5?Code:SELECT table1.* FROM table1, table3 WHERE table1.field1 = table3.tbl1field1 AND table3.table2ID = 5 // 5 is an example ID from table2