A admin Administrator Staff member Aug 21, 2008 #1 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
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
