I'm trying to get a query working, but I cant seem to join the three tables I need without getting a 1066 - Not unique table/alias: 'tbl_master_items' error.
Here's my query (excuse the format - navicat)
Code: Select all
SELECT
`tbl_master_items_type`.`name`,
`tbl_master_items_type`.`MT_PK`
FROM
`tbl_master_items_type`
JOIN `tbl_master_items` ON (`tbl_master_items_type`.`MT_PK` = `tbl_master_items`.`MT_ID`),
`tbl_vendor_menu_items`
JOIN `tbl_master_items` ON (`tbl_vendor_menu_items`.`MI_ID` = `tbl_master_items`.`MI_PK`)I'm using mySQL 3.23.49 (according to phpinfo).
Cheers