I'm sort of new/rusty to SQL and I was trying to figure out the best way to do this problem. I'm creating a database for tracking a football pool. I'm kind of stuck on displaying the Games database. The Games database has a home team ID and an away team ID as well as the winning team ID. Thus I need to do three "lookups" per record on the Teams database to get/display the full name of the teams for viewing.
Is the best way to do this is by using temporary tables for merging? There are about 15 games that need to be displayed at once. I'm using PHP for the interface to MySQL, so I know I could also do it using arrays. But I would presume I would want to stay away from doing 45+ selects (3 x 15). Any ideas/advice are appreciated. -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
