You can use the UNION operator to simulate a LEFT OUTER JOIN. It would look something like this:

SELECT columnlist
FROM titles, sales
WHERE title.title_id = sales.title_id
AND something else
UNION
SELECT columnlist
FROM titles
WHERE title_id NOT IN
(SELECT title_id FROM sales)

Don't forget the semi-columns <g>.

-Mike