2 Table MySql Query Assist
Posted: Sun Jul 05, 2009 9:20 pm
Kind gentlemen / ladies,
Here are the two tables I am working with ... the important columns at least --
Table #1 - items (catid -- which contains the ID# of whatever category it is from table #2)
Table #2 - categories (id,name)
I want to be able to display a search results page that allows me to sort in alphabetically ascending order all the pertinent information from Table #1 but based on the NAME column from Table #2.
So basically:
Select everything from items,categories order by categories name
Any assistance would be greatly appreciated, thanks.
Here are the two tables I am working with ... the important columns at least --
Table #1 - items (catid -- which contains the ID# of whatever category it is from table #2)
Table #2 - categories (id,name)
I want to be able to display a search results page that allows me to sort in alphabetically ascending order all the pertinent information from Table #1 but based on the NAME column from Table #2.
So basically:
Select everything from items,categories order by categories name
Any assistance would be greatly appreciated, thanks.