select distinct name, phone
from rec.customers, rec.salesorders, rec.sodetail, rec.inventory
where id=custid
and
rec.salesorders.sonum=rec.sodetail.sonum
and
rec.sodetail.partno=rec.inventory.partno
and
description='Flaming Widget'
/