[thelist] MySQL query help

NanHarbisonSmith at aol.com NanHarbisonSmith at aol.com
Sun Jun 9 07:11:16 CDT 2002


--
[ Picked text/plain from multipart/alternative ]
>From your raw output email, it looks like everything should be in lowercase,
I always have trouble with queries when I accidentally use the wrong case.
Nan

In a message dated 6/9/2002 2:18:20 AM Eastern Daylight Time,
lists at irubin.com writes:
> The query (modified a bit to reflect real column names) returns only two
> rows out of an expected 5. Any thoughts?
>
> SELECT Tasks.ID, Tasks.CatID, Tasks.ID, taskcategory.ID,
> taskcategory.Task, taskstatus.ID, taskstatus.TStatus FROM Tasks,
> taskcategory, taskstatus WHERE Tasks.ID = taskcategory.ID AND Tasks.ID =
> taskstatus.ID
>
> Thanks again.


Nan Harbison Smith
481 Elm Street
Concord, MA 01742
978-369-1224
978-369-1681

Deja Moo -- the feeling that you've heard this bull before






More information about the thelist mailing list