I have two table
Table 1
id cat
1 food 2 drinks 3 homes
table 2
item cat qty
beef 1 43 lamb 1 33 7up 2 233 pot 3 33
can you help writing the sql statement to to get the item, cat, qtg and its associated category from table 1
select table2.item, table1.cat, table2.qty from table2 left join table 1 on table1.id = table2.cat
