I'm trying to figure out two queries from the following structure.
SURVEY
SurveyID (PK)
PERSON_SURVEY
PersonID (PK,FK)
SurveyID (PK,FK)
PERSON
PersonID (PK)
1. I have a join table PERSON_SURVEY with a composite key of PersonID
and SurveyID. How can I query for all the entries where PersonID =
'something'. Do I use an expression or a path? Since this is a composite
key and is part of the PK. In general, is it preferred to stay away from
composite keys in the join tables?
The second one is: Is there any way I can formulate a query that returns
all the entries in the PERSON table that are not mentioned in the
PERSON_SURVEY table for a specific survey. In other words, I'd like to
get a list of people that haven't been assigned anything yet. I'm having
complete brain freeze.
If anyone could spare some time to take a look that would be awesome.
Fredrik
This archive was generated by hypermail 2.0.0 : Wed May 03 2006 - 13:02:02 EDT