RE: Passing 2 parameters into a nested select statement

From: Jamadagni, Rajendra <rajendra.jamadagni_at_espn.com>
Date: Fri, 25 Aug 2000 15:33:49 -0400
Message-Id: <10600.115595@fatcity.com>

select     icons,
          admdatetime,
          ther,
          therin
from       inpatient
where      icons  Between 85 and 93
and        (icons, admdatetime)  in
          (select icons, max(admdatetime)
           from inpatient
           group by icons)

should work right??

HTH
Raj

---

Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
QOTD: Any clod can have facts, but having an opinion is an art ! Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. Received on Fri Aug 25 2000 - 14:33:49 CDT