I have been working with joins and having alot of success up until now.
What I have is this: SELECT a.merno ,g.mcmid FROM ( total AS a LEFT JOIN mcmid AS g ON (g.merno=a.merno)) WHERE a.repno='111111' AND a.month='2003-11-01' AND g.month='2003-11-01' ORDER BY merno
Currently it is returning only 178 records where it should be returning 407 records.
The 401 records are what are returned from the total table.
I beleave the problem is with the: AND g.month='2003-11-01'
any clues?
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
