Контрагент

select contragent_id, contragent from contragent order by contragent

Договор

select d.contract_id, d.contract, d.dt_contract, k.contragent from contract d join contragent k on (d.contragent_id=k.contragent_id) order by contract