SELECT calls.*, ; NVL(cust.custno, "Custno?") AS custno, ; NVL(cpcust.id, "id?") AS id, ; NVL(cust.phone, "Phone?") AS phone, ; NVL(cust.name, "Name?") AS name, ; NVL(cust.city, "City?") AS city, ; NVL(cpcust.state, "state?") AS state, ; NVL(cust.zip, "zip?") AS zip, ; NVL(cust.terri, "??") AS terri, ; NVL(cust.email, "email?") AS email ; FROM calls LEFT OUTER JOIN cust ; ON calls.custno = cust.custno ; AND calls.id = cust.id ; WHERE ; BETWEEN(calls.date, {^2010/03/09}, {^2010/03/09}) ; AND calls.user = 'USER NAME HERE' ; ORDER BY calls.date DESCENDING, calls.start DESCENDING ; INTO CURSOR mycursor