<http://schema.org/articleBody>
"I am writing an rpg program connecting to sql server that joins several files together. One of the files has or potentially can have multiple records and I only want to select the record with the most current hold date. Here is my original sql statement sqlstmt = 'select * from gisowner.jtx_jobs a + left outer join gisowner.jtx_job_holds b + on a.Job_id = b.Job_id + left outer join gisowner.JTX_HOLD_TYPES c + on b.HOLD_TYPE_ID = c.id + join gisowner.wmx_workflow d + on a.job_id = d.job_id where a.job_Type_I..."^^<http://www.w3.org/2001/XMLSchema#string>
<http://archive.midrange.com/midrange-l/201404/msg00705.html>