Code: Select all
SELECT t.MyKey
FROM mytable t
WHERE Service_Date BETWEEN t.Start_Date AND t.End_Date
Code: Select all
SELECT t.MyKey
FROM mytable t
WHERE :1 BETWEEN t.Start_Date AND t.End_Date
Moderators: chulett, rschirm, roy
Code: Select all
SELECT t.MyKey
FROM mytable t
WHERE Service_Date BETWEEN t.Start_Date AND t.End_Date
Code: Select all
SELECT t.MyKey
FROM mytable t
WHERE :1 BETWEEN t.Start_Date AND t.End_Date
Code: Select all
SELECT t.Start_Date, t.MyKey
FROM mytable t
WHERE :1 BETWEEN t.Start_Date AND t.End_Date