25.02.2015 22:38, martin_gorr...@yahoo.es wrote:
I have this SQL:
select t1.*, t2.* from
(select a1.BJAR,a1.TKEY,a2.OWNR,a2.TIPO,a2.DSCR as ADSCR
from TL1_1 a1 left outer join BJAR a2 on a1.BJAR=a2.BJAR) t1
left outer join
(select b1.BJTX,b1.TKEYT,b2.OWNR as
25.02.2015 23:29, martin_gorr...@yahoo.es wrote:
select t1.*, t2.* from
(select a1.BJAR,a1.TKEY,a2.OWNR,a2.TIPO,a2.DSCR as ADSCR
from TL1_1 a1 left outer join BJAR a2 on a1.BJAR=a2.BJAR) t1
left outer join
(select b1.BJTX,b1.TKEYT,b2.OWNR as TOWNR,b2.BJAR,b2.DSCR as
Hi Dmitry,
Thank you. I agree with you about ORDER BY inside t2, my original code does
not have it, and I added it trying to find a solution. Here is what you asked
for:
Starting transaction...
Preparing query: select t1.*, t2.* from
(select a1.BJAR,a1.TKEY,a2.OWNR,a2.TIPO,a2.DSCR as