|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
July 25th, 2003, 10:33 AM
|
|||
|
|||
|
Selecting Entries from a JOIN
I want to populate an asp select dropdown with all the people (by unique id) in a roster table that don't appear in a forms table. The two tables are joined by a relationship. Should I use a join, and if so, what is the syntax for the ON clause? For instance:
"SELECT * FROM Roster r INNER JOIN Forms f ON ??? WHERE r.TeamID = 10" Or would it be easier to throw them all in the select and then take out the duplicates (I don't know how to 'remove item' in asp)? Thanks!!
|
|
#2
July 25th, 2003, 03:36 PM
|
|||
|
|||
|
Please post the DDL and how the tables are related.
|
|
#3
July 25th, 2003, 03:41 PM
|
|||
|
|||
|
I got it figured out. I used a left outer join. You learn something every day.
Thanks!
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Selecting Entries from a JOIN |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
