Hello all,
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?