[thelist] MySQL query help

[Kevin]

> > The query (modified a bit to reflect real column names) returns
> > only two rows out of an expected 5. Any thoughts?
>
> try matching on the other ids
>
>    SELECT Tasks.ID, Tasks.CatID, Tasks.ID
>            , taskcategory.ID, taskcategory.Task
>            , taskstatus.ID, taskstatus.TStatus
>     FROM Tasks, taskcategory, taskstatus
>       WHERE Tasks.CatID = taskcategory.ID
>             AND Tasks.StatusID = taskstatus.ID
>
> rudy
>

Only 1 record is returned with the appropriate fields (out of expected 5) -
any other thoughts?

Thanks

--Kevin
lists at irubin.com