MySQL merge

[meghatronic]

I have two tables in mysql that I'd like to easily link about a shared field (uid).

One table has 20 rows (and unique uid), the other has multiple rows referring to the single uid.

e.g.

food table:
type                uid
vegetable         1
alcohol             2
meat                3

item table:
item           uid
wine           2
beer           2
chicken       3

to:

end table:

item table:
item           type
wine           alcohol
beer           alcohol
chicken       meat

I was about to link the tables using php but wondered if there was an easier way?

 

[meghatronic]

I knew it was simple!

Cheers... I did it in phpmyadmin (cross join > output > new table > input) much quicker.