I have three tables as below
Timesheet – weekdate, id, name, hrs
Bill Table – weekdate, id, name, rate, hrs
Resource Table – fromweekdate, toweekdate id, name, rate, po, poname
I need a query that satisfies the following conditions:
1) Select all the records from Timesheet
2) Select weekend, rate, hrs from Bill Table for the weekends of Timesheet Table
3)Select the resouce record should the Timesheet weekend fall with between the Fromweekdate amd Toweekdate
Please help me with query on the above requirement.
Thanks
Gary
