General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2003 Server
I have not done any programming in over two years and I have to do a few tasks here. Can someone please tell me what is wrong with this statement:
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, ;
WHERE invoice.inv_date >= from_date .and. invoice.inv_date <= to_date FROM invoice, jobs, customer ;
INNER JOIN customer on customer.cust_no = invoice.cust_no ;
INNER JOIN jobs ON jobs.job_no = invoice.job_no ;
GROUP BY jobs.csr_init ORDER BY jobs.csr_init, invoice.inv_date ;
INTO CURSOR csr_detl
The invoice and jobs table have a 1:1 relationship, and customer has a 1:many relationship with jobs and invoices. I keep getting a blank table when I run the above statement. And I have checked there is plenty of data that should be selected. When I took out the INNER JOINs the selection was still going after 20 minutes so I canceled it (I am running a 3.2Ghz PC with 1Gb RAM).
Any help will be appreciated.
Thanks, Peter Renton
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