Please post the SQL from your query. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of db_2010 Sent: Friday, November 18, 2005 5:02 PM To: [email protected] Subject: [ms_access] Multiple Left Joins 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 ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/u8TY5A/tzNLAA/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/
