Results 1 to 2 of 2

Thread: t+1

  1. #1
    Join Date
    May 2012
    Posts
    3

    Unanswered: t+1

    Hey,

    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 help me with this?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    is this an oracle question or MySQL?
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •