Dear Kervin, > What does the the 'where' command say?
(See the original start of the thread for the whole kaboodle), but here's the offending select: select r.kp, substr(r.kp,1,13) as records, r.result2, r.result4, r.result12, min(1,(r.arecords2/100)) as ap2, min(1,(r.arecords4/100)) as ap4, min(1,(r.arecords12/100)) as ap12, min(1,(r.arecords2/100))*d.dhj as ad2, min(1,(r.arecords4/100))*d.dhj as ad4, min(1,(r.arecords12/100))*d.dhj as ad12, d.ourgrps, d.dhj from answers_read r, dhj_pp d where r.kp = d.kp order by r.kp, r.cost limit 10; Kind regards Derek.