This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1A2F3.649B075E
Content-Type: text/plain

<Off the cuff answer>
Create a user list Table.
Create 2 tables for each question. One to store answers to the questions and
the other to store the options. eg

tblUsers
UserID (PK int)
txtFName (txt)
txtLName (txt)

tblDayOff
DayOffID (PK, int)
intActivityID (FK, int)
intUserID (FK int)

tblDayOffActivities
ActivityID (PK, int)
txtActivity (txt)

</Off the cuff answer>

regards
David Cameron
nOw.b2b
dcameron@i...

-----Original Message-----
From: brettstil@y... [mailto:brettstil@y...]
Sent: Tuesday, 22 January 2002 1:21 PM
To: sql language
Subject: [sql_language] match making sql


Hello.  I want to build a match matching web site.  For example, guys and 
girls enter different preferences.  What do you like to do on a day off?  
A) hiking, B) sleep in, C) museusm, D) sports.  Then those results will be 
put into a database.

My questions are: how do I structure the data to the database and how do I 
run SQL to give every person their top 10 matches?  Thanks!

$subst('Email.Unsub').