Question:
I am doing calculations in reports using SQL and FoxPro 2.6 for Windows. My SQL query works fine, except for one thing. I want to display information in the reports on the basis on some input. For instance, I have a screen that takes input from a date range and an employee ID.
I have been able to do the date part but I have not been able to display only the information of the employee ID. The employee ID that I am entering has the variable m.id.
The following is the query I wrote:
clear readSELECT Quality.threadin, Quality.picks, Quality.widthfab, Quality.meters,; Quality.id, quality.meters*quality.picks*.01 as twages; FROM Quality, Employee; WHERE Employee.id = Quality.id; AND Quality.date BETWEEN m.fdate and m.tdate; ORDER BY Quality.id;report form individual.frx previewuse
Where do I add the employee comparison?
Answer:
You are 95 percent of the way there. You just need to add an additional WHERE condition:
SELECT Quality.threadin, Quality.picks, Quality.widthfab, Quality.meters,; Quality.id, quality.meters*quality.picks*.01 as twages; FROM Quality, Employee; WHERE Employee.id = m.id AND Employee.id = Quality.id AND; AND Quality.date BETWEEN m.fdate and m.tdate; ORDER BY Quality.id;