CODEWITHSUNDEEP
sqlms-access
user5784310
user5784310

Reputation:

Joining 4 Tables in MS ACCESS

Individual Table: IndividualID Age Name Sex

Whistle Table WhistleID BoutID IndividualID ContorFilePath

Bout: BoutID FilePath Length Offset Activity

Recording: RecordingID RecordingName Date Depth Location Weather

These are the tables. I want to select the BoutID when the user enters a Specific Name (From individual Table) and Date (From recordingTable) but this involves joining 4 tables? I've only ever joined two tables so im unsure of the syntax required?

Many thanks

Upvotes: 0

Views: 698

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269443

MS Access multiple joins require parentheses -- which are not generally recommended when using other databases. Also, the join keyword is INNER JOIN rather than just JOIN.

So the structure for 4 tables would look like:

select . . .
from (((a inner join
        b
        on . . .
       ) inner join
       c
       on . . .
      ) inner join
      d
      on . . .

Upvotes: 1

Related Questions