Re: trying to join twice

On 29 Mar 2013 14:58, Stone, Joel wrote:

Receive error as shown on last line.

Can this be done?

select
a.ACNTNMB,s.sumAFNLAPL,s.sumAESTAPL
,AOPNBLA,ATRMQNT,ATRMQNT - AOPNBLA
from conterms as a
inner join
lateral (
select b.acntnmb
,sum(b.AFNLAPL) as sumAFNLAPL
,sum(b.AESTAPL) as sumAESTAPL
from applsjct as b
where b.ASHPTYR = '13'
and a.ACNTNMB = b.ACNTNMB
and a.ADVSNCD = b.ADVSNCD
group by b.ACNTNMB
) as s
on a.ACNTNMB = s.ACNTNMB
inner join applship p
on p.ASHPNBR = s.ASHPNBR
p.ABLDNGD = s.ABLDNGD
p.APLSQNB = s.APLSQNB
where s.sumAESTAPL <> ATRMQNT - AOPNBLA

Token P was not valid. Valid tokens: FOR WITH FETCH ORDER UNION EXCEPT

Requesting the statement in STRSQL, the cursor should have been positioned to the "P" on the third to last line with "p.ABLDNGD = s.ABLDNGD". Conspicuously absent are the logical operators. Presumably what was desired:

inner join applship p
on p.ASHPNBR = s.ASHPNBR
and p.ABLDNGD = s.ABLDNGD
and p.APLSQNB = s.APLSQNB
where s.sumAESTAPL <> ATRMQNT - AOPNBLA