I can't help you if you won't post the SQL from your query. Open the query in Design view and choose SQL View from the View menu.
But after reading the KB article, I expect you're doing something like: SELECT A.*, B.* FROM A LEFT JOIN B ON A.Key = B.Key WHERE B.SomeField = "somevalue" As the article tries to explain, as soon as you apply criteria to the "right" side of a "left" join, the join acts like an INNER JOIN - which is correct. The database engine applies the WHERE *after* the JOIN, so filtering any field in B eliminates all the Nulls. Adding a test for Or Is Null won't work either because you'll eliminate all rows from A that do match some row in B. What you really want is: SELECT A.*, BF.* FROM A LEFT JOIN (SELECT B.* FROM B WHERE B.SomeField = "somevalue") As BF ON A.Key = BF.Key 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 Shaveta Kamran Sent: Sunday, November 20, 2005 1:36 AM To: [email protected] Subject: RE: [ms_access] Multiple Left Joins 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 ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/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/
