> So if I should store all of my data in separate tables, > what would be the best way to query them or structure them?
let me see if i can whip up an example from your earlier email > How do I account for the 10 other variables that need to be true in > order for the users to be matched up? that all depends on where those other variables are stored, and whether they in fact also involve one-to-many relationships (or are just attributes on the user table) > Is it possible to join 10 tables efficiently? sure, it all depends on what kind of database you're running -- oracle, db2, and sql/server, for example, would usually have no problem with that, assuming the tables are properly indexed back in a moment with an example rudy http://rudy.ca/ - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "rudy" <[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)
