>>SELECT invoice.inv_date, invoice.job_no, invoice.inv_no, ; >> invoice.cust_no, jobs.csr_init, jobs.total_frames, ; >> customer.company, customer.firstname, customer.lastname, ; >> FROM invoice ; >> INNER JOIN customer on customer.cust_no = invoice.cust_no ; >> INNER JOIN jobs ON jobs.job_no = invoice.job_no ; >> WHERE invoice.inv_date BETWEEN from_date AND to_date ; >> ORDER BY jobs.csr_init, invoice.inv_date ; >> INTO CURSOR csr_detl >>Notice that only one table is used in FROM clause because the rest are JOINed to it. I also remove GROUP BY clause because there're no aggregate functions used.