Use this page to create the Join By clause in your SQL query. This clause is required if you specify more than two files in the From clause. The Join By clause determines how to join records from the specified files. You provide the names of the fields you want to use to join the records.