Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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
Reply With Quote
  #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.
Reply With Quote
  #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.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 04:27 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.