a) Table1 contains includes records w/ null values that should be preserved. b) Table1 linked with Table 2 via Left Join. c) Table1 linked with Table3 via Left Join
Resulting query only includes records from Table1 where a match exists in TAble 3 - behaving like an inner join. If I remove table3 from query, I obtain accurate results (All TAble1 records with and without matching TAble2 records) Is this related to a Msoft bug? Links below - somewhat document issue... http://support.microsoft.com/default.aspx?scid=kb;EN-US;275058 http://support.microsoft.com/kb/239114/#XSLTH3131121123120121120120 ------------------------ Yahoo! Groups Sponsor --------------------~--> 1.2 million kids a year are victims of human trafficking. Stop slavery. http://us.click.yahoo.com/WpTY2A/izNLAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
