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

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.

thanks.