Here is how I would do it, oversimplified of course.
Table 1 - person
person_id name
1 me
2 you
Table 2 - location
location_id location
1 Ontario
2 Nevada
3 France
Table 3 - person_location
person_id location_id
1 2
1 3
2 1
1 1
2 3
Sample query, Who chose Ontario?
select name
from person p, person_location pl, location l
where p.person_id = pl.person
and pl.location_id = l.location_id
and l.location = 'Ontario'
Will that work for your application? Don't forget your primary and foreign
keys.
********************
So if I should store all of my data in separate tables, what would be the
best way to query them or structure them?
Using the province example again, would I use the provinces as column
headings and place a true or false value for each one selected by the user
along with their userID?
How do I account for the 10 other variables that need to be true in order
for the users to be matched up?
Is it possible to join 10 tables efficiently?
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: [EMAIL PROTECTED]
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)
