I'm very new to 4GL in Progress OpenEdge 10.1 very familiar with SQL92. My question is this. Is there a IN condition within a WHERE clause in 4GL?
I want to convert the following SQL statement into 4GL:
SELECT jc_job.kco, jc_job_num, jc_costcode.jcc_cost
FROM jc_job INNER JOIN ON jc_job.job_num = jc_costcode.job_num
WHERE kco IN (11,12,16,17)