select ce.aid,
       ai.aname,
	   ai.cruisingrange
from dbo.Certified ce, dbo.Aircraft ai
where ce.eid='804'
and   ce.aid=ai.aid;