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 |
|
CMangano
Starting Member
16 Posts |
 Posted - 2001-09-26 : 17:09:31
|
| Assuming I have a table that looks like:Part Spec Value---- ---- -----1 x y2 x z3 x y1 a b2 a d3 a bHow do i write a query to return distinct parts that have spec x with a value of y, or spec a with a value of b? So, my result set would be:Part----13 I am sure it is something easy and it is just not clicking for me. Thanks in advance. |
|
|
|
|
|
Selecting Multiple Rows for Same Values