[thelist] MySQL query help

Kevin lists at irubin.com
Sat Jun 8 21:09:01 CDT 2002


Hello,

I am having some trouble with a query and can't figure it out ...

There are three tables:

Tasks
======
ID
CatID
StatusID


Categories
=========
ID
CategoryName

Status
=========
ID
StatusTitle

I would like to select all the records in the tasks table, the result
however should contain the values from the Categories and Status table. I
hope this makes sense.

Any help will be appreciated.

Thanks.

--Kevin
lists at irubin.com






More information about the thelist mailing list