[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