Less than date Query.
How to get the query out put if Even if one V_Date is less than the Admission_date the query should show all the data.
id V_date Admission_date
101 4/1/2001 5/1/2001
102 4/1/2001 5/1/2001
103 4/1/2001 5/1/2001
104 4/1/2001 5/1/2001
105 4/1/2001 5/1/2001
106 6/1/2001 5/1/2001
Even if one V_Date is less than the Admission date the query should pick up all the data.
select * from X where V_DATE < Admission_Date gives only
101 4/1/2001 5/1/2001
102 4/1/2001 5/1/2001
103 4/1/2001 5/1/2001
104 4/1/2001 5/1/2001
105 4/1/2001 5/1/2001
Still missing 106.
Thank you..