View Single Post
12-15-2007, 11:52 AM
Join Date: Dec 2007
I don't have a problem just for future reference.
I see alot about left joins and stuff, and I think it's used for what I'm about to explain.
Say I have something like this for games:
id - title - description - categoryid
1 - Game - Description - 1
And the category table is like this:
id - category
1 - Games
I could do a query like
select category from categories where id = 'categoryid'
or whatever, but, is there anyway i can do this in one query, so i can select all of the games stuff, and the actual category name
View Public Profile
Send a private message to crazyryan
Find More Posts by crazyryan