I have two tables table1 and table2. I am looking to filter table1 and then join it with table2. I tried some code like that below but I keep getting an error.

SELECT*
FROM table1
WHERE column1 = 'mm'
LEFT JOIN table2
ON table1.keyfield=table2.matchingfield (one to many relationship)

My ultimate goal is to find records in table1 that do not have at least one corresponding record in table2. After the sort.

Please help.