2/27 - JOIN

SELECT t.title_id, t.tile, t.pub_id, p.name
FROM title t, publisher p
WHERE t.pub_id = p.pub_id;