Results 1 to 2 of 2

Thread: t+1

  1. #1
    Join Date
    May 2012

    Unanswered: t+1


    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?

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    is this an oracle question or mysql? | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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