Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-06 : 11:21:47
|
Cathy writes "I am looking for a SQL Server equivalent to something I used to do in Oracle. The following statement will work in Oracle (8), but I can not get it to work in SQL Server (2000). Is my syntax just wrong, or is this not available in SQL Server?
select ordid, prodid, qty
from item
where (prodid, qty) in
(select prodid, qty
from item
where ordid = 605)
and ordid <> 605 " |
|
|
|
|
|
SQL Equivalent to Oracle's Pairwise comparision (multiple-column subqueries)