I have two tables, one a master table of items, and a second which references the first. I am trying to get a list of all items in table 1 which have not be referenced in table 2 but I cant seem to get it to work because of the fact that the column which is different is also the one which links the tables together.
Code: Select all
SELECT
`tbl_master_items`.`name`
FROM
`tbl_vendor_menu_items`
JOIN `tbl_master_items` ON (`tbl_vendor_menu_items`.`MI_ID` <> `tbl_master_items`.`MI_PK`)
WHERE
(`tbl_master_items`.`MT_ID` = '11')I hope that makes sense. Anyhow ... can anyone give me an idea of how/ if this can be accomplished?
Cheers