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 |
|
bishu
Starting Member
1 Post |
 Posted - 2005-05-12 : 02:38:18
|
| If i want to select antim_id from following table using query Q1...which has all the missile_id values returned by another query Q2 .For eg. if Q2 returns 100,300,400my Q1 should return 3000...How to do it.? using ALL will help?DEFUSE_CAPABILITY+----------+------------+| antim_id | missile_id |+----------+------------+| 1000 | 100 || 1000 | 200 || 2000 | 100 || 2000 | 200 || 2000 | 300 || 3000 | 100 || 3000 | 200 || 3000 | 300 || 3000 | 400 || 3000 | 500 |+----------+------------+ |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-05-12 : 02:54:27
|
| Select Distinct antim_id from DEFUSE_CAPABILITYwhere antim_id in (Select antim_id from OtherTable)MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
sql query issue . any solutions ?