Re: my first use of lateral

select a.w1BOL, b.w2sdte
from w1mast a
, lateral ( select c.w2sdte
from w2mast c
where a.w1wacd = c.w2wacd and a.w1sid = c.w2sid
and c.w2sdte<> 0
fetch first row only ) b
where a.w1wacd = 'LAE' and a.w1BOL<> ''

I suspect the LATERAL specification is moot for the given SQL. I
expect that the /same/ SQL, but without the LATERAL keyword, will
function just fine; no errors, and the identical output\effect. It is
the NTE which allows the FETCH FIRST 1 ROW ONLY, not the use of LATERAL.