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)?