[Solved] How do i join 3 tables in mysql? [closed]

by


The solution is to join on the common fields you already indentified:

SELECT item_details.*
FROM item_details
JOIN item_detail_addon USING(Item_Details_Id)
JOIN item_addon USING(Item_Addon_Id)

If some fields on a table have the same name of a field on another table, you can get both by using aliases:

SELECT table1.field1 as table1_field1
     , table2.field1 as table2_field1
     [ .. and so on .. ]

3

solved How do i join 3 tables in mysql? [closed]