with cx as
(SELECT a.MMKT, a.MCLNO,a.mclsuf FROM files/tpclp01 a ,
where a.mclno =b.mclno and a.mclsuf=b.mclsuf and a.mmkt <> b.mmkt)
select d.MMKT, d.MCLNO,d.mclsuf from files/tpclp01 d
where d.mclno =cx.mclno and d.mclsuf=cx.mclsuf
Does anyone see anyting wrong with this. The SELECT inside the WITH statement works all by itself outside the WITH and the fields are all valid fields in the TPCLP01 file.
I keep getting Column qualifier or table CX undefined
I figure I must be overlooking something obvious as I have used the WITH statment before without incident.