[thelist] MySQL query help

Shashank Tripathi sub at shanx.com
Sun Jun 9 03:32:00 CDT 2002


Kevin, I missed this thread. Please repeat your question?

Shashank



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




More information about the thelist mailing list