Mark,
I am getting the same error (SQLCODE -338,SQLSTATE: 42972) when running
the following query!
SELECT COUNT(*)
FROM
(
NNN.FBC8EPU left outer join NNN.FBC9EPU
on
NNN.FBC8EPU.BC8COSOCE = NNN.FBC9EPU.BC9COSOCE
AND
NNN.FBC8EPU.BC8NUMAR = NNN.FBC9EPU.BC9NUMAR
AND
( NNN.FBC8EPU.BC8COSTAT = ' ' AND NNN.FBC9EPU.BC9COSTAT = ' ' ) )
What's wrong here? Any idea how solve the problem?
--
Posted via http://dbforums.com