[firebird-support] Left join derived table

Hello All I'd like to ask how to get below statement working: SELECT A.FIELD_1, A.FIELD_2, D.FIELD_D1, D.FIELD_D2 FROM TABLE_A A LEFT JOIN (SELECT FIRST 1 FIELD_D1, FIELD_D2 FROM TABLE_D D WHERE D.FIELD_3 = A.FIELD_3 ORDER BY D.ID DESC) D ON (1=1) Firebird complains that A.FIELD_3: Column does

Re: [firebird-support] Left join derived table

W dniu 2016-09-28 09:04:07 użytkownik 'Marcin Bury' marcin.b...@studio-delfi.pl [firebird-support] napisał:   Hello All I'd like to ask how to get below statement working: SELECT A.FIELD_1, A.FIELD_2, D.FIELD_D1, D.FIELD_D2 FROM TABLE_A A LEFT JOIN (SELECT FIRST 1 FIELD_D1, FIELD_D2 FROM TABLE_D

Re: [firebird-support] Left join derived table

D2 WHERE D2.FIELD_3 = A.FIELD_3 ORDER BY D2.ID DESC)) Kind Regards, Arno Brinkman ABVisie From: liviuslivius liviusliv...@poczta.onet.pl [firebird-support] Sent: Wednesday, September 28, 2016 12:39 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Left join derived

Re: Re: [firebird-support] Left join derived table

     Kind Regards, Arno Brinkman ABVisie        From: liviuslivius liviusliv...@poczta.onet.pl [firebird-support] Sent: Wednesday, September 28, 2016 12:39 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Left join derived table       W dniu 2016-09-28 09:04:07 użytkownik 'Mar