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 |
|
dr.murthy
Starting Member
2 Posts |
 Posted - 2010-10-21 : 08:36:15
|
| Hi, am facing an issue with below select query ,can any one please help out me to solve this.select * from dm_bankswhere (bank_name,bank_number) in (select distinct bank_name,bank_number from dm_banks where bank_number = '109') |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-10-21 : 08:40:17
|
WHERE bank_name in (...)AND banknumber in (...)But it looks weird...maybe: select * from dm_banks where bank_name in(select bank_name from dm_banks where bank_number='109')
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
dr.murthy
Starting Member
2 Posts |
Posted - 2010-10-21 : 08:50:55
|
| Hi Thanks for respond,My Actual Sql is select * from dm_bankswhere (bank_name,bank_number) in (select distinct bank_name,bank_number from dm_banks_Merit) |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-10-21 : 08:59:21
|
Yes I know  IN() can't be used to give values of multiple columns.Hence my correction was:WHERE bank_name in (...)AND banknumber in (...)
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2010-10-21 : 09:10:38
|
select db.* from dm_banks dbjoin (select bank_name,bank_number from dm_banks_Merit group by bank_name,bank_number) dbm on dbm.bank_name=db.bank_name and dbm.bank_number=db.bank_number
elsasoft.org |
|
|
|
|
|
|
Select query issue