Re: Derived tables - ��������� ����?

[������� �����]

Á ÔÁË  ×ÏÏÂÝÅ ÐÏ 2 ÞÔÅÎÉÑ

select m.ID, (select first 1 d.id from detail1 d where d.MASTER_ID = m.ID 
order by d.id)
from master1 m


×ÏÐÒÏÓ Ë ÒÁÚÒÁÂÏÔÞÉËÁÍ, Á  ÂÕÄÅÔ ÌÉ ËÏÇÄÁ-ÎÉÂÕÄØ ÒÁÂÏÔÁÔØ ×ÏÔ ÔÁËÏÊ ÚÁÐÒÏÓ:

select m.ID, (select first 1 * from detail1 d where d.MASTER_ID = m.ID order 
by d.id)
from master1 m