select nr3.field1, nr3.field2, etc. ; FROM nrh10300 nr3, nrh10200 nr2, nrh14000 nr4;>>yes, it does run if I remove any other field from the nrh14000 table or any other table. I dont think i've exceed the caracter limit.
SELECT some fields, ... nrh14000.Dir_emp ; <<--- This field is the problem > FROM nrh10300 , nrh10200, nrh14000 ; > INTO TABLE outrh\Maemp ; > WHERE nrh10200.Numemp = nrh10300.Numemp ; > AND nrh14000.Numemp = nrh10300.Numemp ; > AND (nrh10300.Numemp < 0 ; > AND nrh10200.Tarchc = 'S' ; > <B>AND nrh10300.Tnoemp < 'J' ; > AND nrh10300.Tnoemp < 'P' ;</b> > AND nrh10300.Tnoemp < 'B' ; > AND nrh10300.Numemp IN ; > (SELECT nrh34100.Numemp FROM nrh34100 WHERE nrh34100.Checador < 0)) ; > AND &cDepSec ; > ORDER BY nrh10300.Numemp>