I have this case.
I want to get all records from a table called workorder where a column called datepaid is within a range, then all rows from a table called wo_adjs where the column woid is equal to the corresponding column in the table workorder called wokey and the colun in wo_adjs = 'L'.
Lets assume the date range is 2015-02-01 to 2015-02-16.
Can someone show me a sql query to do this?
The structure of both tables is attached.