[thelist] MySQL query help

[John Corry]

Try this and see what you get

$query = 'SELECT * FROM Tasks, Categories, Status where Tasks.ID =
Categories.ID AND Tasks.ID = Status.ID'

John Corry

> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org] On Behalf Of Kevin
> Sent: Saturday, June 08, 2002 4:16 PM
> To: Thelist
> Subject: [thelist] MySQL query help
>
>
> 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
>
>
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !