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
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