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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2008-09-04 : 02:34:25
|
| i have a table placements and table participantsparticipants is linked to placements by participantsid(there can be more then one placement per particpant)how can I query all those participants that have more then 1 placement record (records in placements table with that partipantid) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-04 : 02:38:06
|
| [code]SELECT p.*FROM participants pINNER JOIN (SELECT participantid FROM placements GROUP BY participantid HAVING COUNT(1) >1)plON pl.participantid=p.participantid[/code] |
 |
|
|
|
|
|
query help