Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old April 11th, 2012, 06:39 AM
Registered User
Points: 13, Level: 1
Points: 13, Level: 1 Points: 13, Level: 1 Points: 13, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy left join on multiple tables in MS access database 2007 sql code

How to join multiple tables using left join in MS access database 2007 sql code.
Plz do the needful help as soon as possible.
I am trying to join 8 tables. like as
SELECT dbo_INCIDENTSM1.INCIDENT_ID
FROM (((dbo_CM3RM2 INNER JOIN ((dbo_INCIDENTSM1 INNER JOIN dbo_SCRELATIONM1 ON dbo_INCIDENTSM1.INCIDENT_ID = dbo_SCRELATIONM1.SOURCE) INNER JOIN dbo_ACTSVCMGTM1 ON dbo_INCIDENTSM1.INCIDENT_ID = dbo_ACTSVCMGTM1.THENUMBER) ON dbo_CM3RM2.NUMBER = dbo_SCRELATIONM1.DEPEND) INNER JOIN dbo_PROBSUMMARYM1 ON dbo_SCRELATIONM1.DEPEND = dbo_PROBSUMMARYM1.NUMBER) INNER JOIN dbo_CM3RM1 ON dbo_SCRELATIONM1.DEPEND = dbo_CM3RM1.NUMBER) INNER JOIN dbo_ACTIVITYM1 ON dbo_PROBSUMMARYM1.NUMBER = dbo_ACTIVITYM1.NUMBER;


It is not giving error . but data is not displaying.. only column name is diplayed.
Plz help me
  #2 (permalink)  
Old April 11th, 2012, 07:12 AM
Friend of Wrox
Points: 2,473, Level: 20
Points: 2,473, Level: 20 Points: 2,473, Level: 20 Points: 2,473, Level: 20
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2004
Location: India
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
Default

In the JOIN statements please verify that the correct columns are matched with each other. Here are some examples:

http://msdn.microsoft.com/en-us/libr...ffice.12).aspx
__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.
  #3 (permalink)  
Old April 11th, 2012, 07:27 AM
Registered User
Points: 13, Level: 1
Points: 13, Level: 1 Points: 13, Level: 1 Points: 13, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by om_prakash View Post
In the JOIN statements please verify that the correct columns are matched with each other. Here are some examples:

http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

thanks.


Similar Threads
Thread Thread Starter Forum Replies Last Post
More than 1 Left Join in MS Access tovipul21 Access 5 November 21st, 2008 05:58 PM
Got problem when combine 2 tables using left join wkm1925 MySQL 1 March 27th, 2007 04:02 PM
left outer join 2 or 3 tables in ms access keyvanjan Classic ASP Basics 2 February 2nd, 2006 06:42 PM
left outer join 2 or 3 tables in ms access keyvanjan SQL Server ASP 0 January 30th, 2006 03:33 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.