sql query

[bisanthe]

Hi,
How can I run these two query in sinlge statement.

SELECT * from VERIMEGRISI where BANKA_KODU = '1' and VERIMEGRISI = 'JPY.LIB'

SELECT * from VERIMEGRISI where BANKA_KODU = '3' and VERIMEGRISI = 'USD.GOV'

I tried this:

SELECT * from VERIMEGRISI where (BANKA_KODU , VERIMEGRISI) IN (('1','JPY.LIB'),('3','USD.GOV'))

and it doesnt work. I heard that this query is working at Oracle database but it is not a ansi sql standart. I am using mssql 2000. If no way I will run each of them in different select statement but if you have an idea pls help.
Thnx...

 

[SQLDenis]

SELECT * from VERIMEGRISI where BANKA_KODU in( '3','1') and VERIMEGRISI in( 'USD.GOV','JPY.LIB')

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[cLFlaVA]

select *
  from VERIMEGRISI
 where (BANKA_KODU = '1' and VERIMEGRISI = 'JPY.LIB')
    or (BANKA_KODU = '3' and VERIMEGRISI = 'USD.GOV')

*cLFlaVA
----------------------------
[tt]I already made like infinity of those at scout camp...[/tt]
[URL unfurl="true"]http://www.coryarthus.com/[/url]