Step 5: Perform the Join

Use the select statement to perform the join.

select Publisher = p.pubname, Title = b.title
 from publishers p, books b
 where p.pub_id = b.pub_id
 order by p.pubname