Yesterday evening I found an article related to how Access processes WHERE clause prior to Joins. I need to create 2 queries 1) first query will encompass WHERE clause for 3rd table 2) 2nd query will includes 3 joins and one WHERE clause for main table. Following link contains info about this issue. http://support.microsoft.com/?id=208880 Thank you for responding.
John Viescas <[EMAIL PROTECTED]> wrote: 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 SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software --------------------------------- YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. [Non-text portions of this message have been removed] ------------------------ 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/
