General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2003 Server
Sergey,
Thanks so much for the quick response. It was the FROM clause that was causing the problem, it works great now. I appreciate your help.
Regards, Peter
>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.
>
>
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only