SQL to get data between 2 date fields
Posted on 2014-12-05
I need help with an SQL query. I have 2 tables:
Table A, Table B
Table A columns are - order #, Item
Table B columns are - order #, order_date, delivery_date
I want to get all orders/items that are delivered within 1 day of the order date.
Eg: Only return values, If the order date is December 1st, 2014, the delivery date is December 2nd, 2014
Thanks in advance...