Performing the join

Use the select statement to perform the join.

select Publisher = p.pub_name, Title = t.title
 from publishers p, titles t
 where p.pub_id = t.pub_id
 order by p.pub_name