Read this SQL ... JOIN works in the same way as the SELECT statement above: It returns a result set with columns from different tables. The advantage of using an explicit JOIN over an implied one ...