p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   left join on multiple tables in MS access database 2007 sql code (http://p2p.wrox.com/showthread.php?t=87224)

mukta April 11th, 2012 06:39 AM

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

om_prakash April 11th, 2012 07:12 AM

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

mukta April 11th, 2012 07:27 AM

Quote:

Originally Posted by om_prakash (Post 283214)
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.


All times are GMT -4. The time now is 08:18 PM.

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