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
