"sasha" <[EMAIL PROTECTED]> wrote: > > óÍÏÔÒÉ, ÅÓÔØ 3 ÚÁÐÉÓÉ:
SELECT A.*, B.F1, B.F2, B.F3
FROM TABLE_A A
LEFT JOIN (
SELECT PARENT_ID, MIN(RDB$DB_KEY)
FROM TABLE_B
GROUP BY PARENT_ID) AS TEMP (PARENT_ID, DB_KEY)
ON TEMP.PARENT_ID = A.ID
LEFT JOIN TABLE_B B
ON B.RDB$DB_KEY = TEMP.DB_KEY
--
äÍÉÔÒÉÊ åÍÁÎÏ×
