select rental.compname
,rental.aptnum
,customer.custlname
,customer.custfname
from apartment
left outer join rental
on rental.compname=apartment.compname
and rental.aptnum=apartment.aptnum
left outer join customer
on customer.custid=rental.custid
order by customer.custlname,customer.custfnamerental.compname,rental.aptnum
;