[thelist] MySQL query help
rudy
r937 at interlog.com
Sun Jun 9 01:31: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
More information about the thelist
mailing list