var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I am trying to grab data from two tables.
1. Grab data from first table which would look like this
Date Item Qty
01/24 Table 10
02/28 Chair 5
03/01 Table 4
2. Now I want to grab the associated price from a different table. But the catch is that I want t+1 date's price.
So in first row I would want price for 01/25 or the next business day which ever is the least. Again for 02/28 I would want the price of 5 chairs as of 02/29.
Can someone please help me with this?
is this an oracle question or mysql?