"sasha" <[EMAIL PROTECTED]> wrote: > > ÎÁ ÓÁÍÏÍ ÄÅÌÅ ÎÁÄÏ ÄÖÏÊÎÉÔØ ÎÅ Ó ÁÇÒÅÇÁÔÁÍÉ, Á Ó ÐÅÒ×ÏÊ > ÐÏÐÁ×ÛÅÊÓÑ ÚÁÐÉÓØÀ, ËÁË Ñ ÒÁÎØÛÅ ÓÐÒÁÛÉ×ÁÌ
SELECT A.*, B.NAME FROM TABLE_A A LEFT JOIN ( SELECT PARENT_ID, MIN(NAME) FROM TABLE_B GROUP BY PARENT_ID) AS B (PARENT_ID, NAME) ON B.PARENT_ID = A.ID -- äÍÉÔÒÉÊ åÍÁÎÏ×
