At this link
I saw this example which selects all records from one table that do not exist in another table.
So it looks for the records in table t1 that do not exist in table t2
FROM table1 t1
LEFT JOIN table2 t2 ON t2.name = t1.name
WHERE t2.name IS NULL
What's the syntax to look for records in two tables?
So look for the records in table t1 that do not exist in table t2 or table t3 ?