Hi Andrew,
The JTX query framework expects you to always select a field from the jobs table. If the "Jobs" table is not in the "FROM" clause, the query is not considered valid. Unfortunately the error message displayed is probably not that accurate.
To accomplish what you are trying to do, here is what I did -
Select
JTX_JOBS.JOB_ID
From
JTX_JOBS,sde.jtx94.JTX_JOB_HOLDS
Where
sde.jtx94.JTX_JOB_HOLDS.job_id = sde.jtx94.JTX_JOBS.job_id AND sde.jtx94.JTX_JOB_HOLDS.released_date IS Null
Basically, I am selecting job id from the jobs table where the released date is null. I had to do a join of the jobs table to the holds table, hence the jobs.job_id = holds.job_id
I hope this helps!
Thanks,
Tope