SELECT T.title, P.pub_name FROM 
pubs..publishers P
OUTER APPLY
(SELECT TOP 1 title from pubs..titles
where P.pub_id = pub_id
ORDER BY Price
) AS T
a
