SELECT rcm_pk, cmt_custname, rlc_number; FROM RailComp, RailCars, CustMast; WHERE rcm_rlc_fk = rlc_pk AND; rcm_custcode = cmt_custcode AND; NOT DELETED() AND; NOT rlc_final_bill AND; rlc_rectype = "R" AND; ASCAN(laCustCode,custmast.cmt_custcode,1) > 0; ORDER BY rcm_custcode, rlc_number, rcm_compdesc; INTO CURSOR WouSel;I tried to change it to use a dynamically created cusstomer list, but I get a 'Line is too long' error when I
SELECT rcm_pk, cmt_custname, rlc_number; FROM RailComp, RailCars, CustMast; WHERE rcm_rlc_fk = rlc_pk AND; rcm_custcode = cmt_custcode AND; NOT DELETED() AND; NOT rlc_final_bill AND; rlc_rectype = "R" AND; INLIST(rcm_custcode, 'ABCDE','ABL24','ACA30','ACM17'); ORDER BY rcm_custcode, rlc_number, rcm_compdesc; INTO CURSOR WouSel;Is there a way to do this with a join?