[thelist] MySQL query help
Kevin
lists at irubin.com
Sun Jun 9 02:03:01 CDT 2002
> > 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
More information about the thelist
mailing list