SQL provides several different statements for performing ... JOIN works in the same way as the SELECT statement above: It returns a result set with columns from different tables.