equivalent of Oracle's EXISTS or IN 1

[glendacom]

I'm trying to do a query in sql*server that I know how to do in oracle ... can someone tell me the equivalent in sql*server. In Oracle the query would be:

select fieldName1, fieldName2
from Table1
where fieldName1 in (select fieldName1
from Table2)

or

select fieldName1, fieldName2
from Table1
where exists (select 'x'
from Table2
where Table1.fieldName1 = Table2.fieldName2)

My Oracle is very rusty so I'm not absolutely positive of the syntax in the second example but hopefully you get the idea.

 

[cheyney]

the first query should work in sql server...not sure why it wouldn't be working for you.

 

[tlbroadbent]

The 2nd query will also work in SQL Server. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[glendacom]

sorry, I guess I didn't make myself completely clear. Yes, I know both versions work in SQL*Server but I thought there was a much "cleaner" way to do it in SQL*Server and that was what I was after.

Thanks for the responses.

 

[tlbroadbent]

You can also use a JOIN in the following manner.

select table1.fieldName1, table1.fieldName2
from Table1
join Table2
on Table1.fieldName1 = Table2.fieldName2
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[glendacom]

thanks, Terry ... that is exactly what I wanted! A star for you!