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
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
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
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