Use the select statement to perform the join.
select Publisher = p.pubname, Title = t.title from publishers p, titles t where p.pub_id = t.pub_id order by p.pub_name
