Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
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.
>
>
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement