USE pubs
go
select t.title_id, t.title, s.qty
from titles as t
	left outer join sales as s 
		on t.title_id = s.title_id
where qty is null
order by 3

select t.title_id, t.title, s.qty
from titles t, sales s 
where t.title_id *= s.title_id and qty is null
order by 3