[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