The JOIN clause combines related data from multiple tables into one set of results.

Selecting data from two tables with a common _FileId.

Selecting data from three tables with common _FileId and _ChannelNr for top 50000 rows.