Received: from slip1.raccoon.com (slip1.raccoon.com [165.90.135.16]) by hub.org (8.9.2/8.9.1) with ESMTP id SAA89845 for ; Thu, 18 Mar 1999 18:45:44 -0500 (EST) (envelope-from perdue@raccoon.com) Received: from timnt (tim.desmoinesnet.com [165.90.140.11]) by slip1.raccoon.com (8.8.7/8.8.7) with SMTP id RAA07087 for ; Thu, 18 Mar 1999 17:45:09 -0600 Message-ID: <011901be7199$4278a390$0b8c5aa5@timnt.weather.net> Reply-To: "Tim Perdue" From: "Tim Perdue" To: Subject: Stuck on SQL - Any Takers? Date: Thu, 18 Mar 1999 17:44:26 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 I have a table where each record has nine player fields, like this: tbl_teams ( fld_team_no int primary key, fld_cust_no int, fld_athlete1 int, fld_athlete2 int, fld_athlete3 int, fld_athlete4 int, fld_athlete5 int, fld_athlete6 int, fld_athlete7 int, fld_athlete8 int, fld_athlete9 int ); I'm trying to build a new table that pulls the related player's name and points from another table, but it isn't working. I'm getting this error: ERROR: create: repeated attribute "fld_player_last" Is there a better way to write this query? SELECT tbl_cust.fld_cust_name, tbl_zip_codes.fld_zip_code, tbl_zip_codes.fld_city_name, tbl_zip_codes.fld_state_short, tbl_zip_codes.fld_area_code, tbl_teams.fld_team_no, tbl_athlete_stats_1.fld_player_last, tbl_athlete_stats_1.fld_player_first, tbl_athlete_stats_1.fld_total_points_ytd, tbl_athlete_stats_2.fld_player_last, tbl_athlete_stats_2.fld_player_first, tbl_athlete_stats_2.fld_total_points_ytd, tbl_athlete_stats_3.fld_player_last, tbl_athlete_stats_3.fld_player_first, tbl_athlete_stats_3.fld_total_points_ytd, tbl_athlete_stats_4.fld_player_last, tbl_athlete_stats_4.fld_player_first, tbl_athlete_stats_4.fld_total_points_ytd, tbl_athlete_stats_5.fld_player_last, tbl_athlete_stats_5.fld_player_first, tbl_athlete_stats_5.fld_total_points_ytd, tbl_athlete_stats_6.fld_player_last, tbl_athlete_stats_6.fld_player_first, tbl_athlete_stats_6.fld_total_points_ytd, tbl_athlete_stats_7.fld_player_last, tbl_athlete_stats_7.fld_player_first, tbl_athlete_stats_7.fld_total_points_ytd, tbl_athlete_stats_8.fld_player_last, tbl_athlete_stats_8.fld_player_first, tbl_athlete_stats_8.fld_total_points_ytd, tbl_athlete_stats_9.fld_player_last, tbl_athlete_stats_9.fld_player_first, tbl_athlete_stats_9.fld_total_points_ytd, (tbl_athlete_stats_1.fld_total_points_ytd+ tbl_athlete_stats_2.fld_total_points_ytd+ tbl_athlete_stats_3.fld_total_points_ytd+ tbl_athlete_stats_4.fld_total_points_ytd+ tbl_athlete_stats_5.fld_total_points_ytd+ tbl_athlete_stats_6.fld_total_points_ytd+ tbl_athlete_stats_7.fld_total_points_ytd+ tbl_athlete_stats_8.fld_total_points_ytd+ tbl_athlete_stats_9.fld_total_points_ytd) AS fld_team_score INTO tbl_ranked_teams FROM tbl_athlete_stats tbl_athlete_stats_1, tbl_athlete_stats tbl_athlete_stats_2, tbl_athlete_stats tbl_athlete_stats_3, tbl_athlete_stats tbl_athlete_stats_4, tbl_athlete_stats tbl_athlete_stats_5, tbl_athlete_stats tbl_athlete_stats_6, tbl_athlete_stats tbl_athlete_stats_7, tbl_athlete_stats tbl_athlete_stats_8, tbl_athlete_stats tbl_athlete_stats_9 WHERE tbl_athlete_stats_1.fld_player_number = tbl_teams.fld_athlete1 and tbl_athlete_stats_2.fld_player_number = tbl_teams.fld_athlete2 and tbl_athlete_stats_3.fld_player_number = tbl_teams.fld_athlete3 and tbl_athlete_stats_4.fld_player_number = tbl_teams.fld_athlete4 and tbl_athlete_stats_5.fld_player_number = tbl_teams.fld_athlete5 and tbl_athlete_stats_6.fld_player_number = tbl_teams.fld_athlete6 and tbl_athlete_stats_7.fld_player_number = tbl_teams.fld_athlete7 and tbl_athlete_stats_8.fld_player_number = tbl_teams.fld_athlete8 and tbl_athlete_stats_9.fld_player_number = tbl_teams.fld_athlete9 and tbl_teams.fld_cust_no = tbl_cust.fld_cust_no and tbl_cust.fld_zip = tbl_zip_codes.fld_zip_code ORDER BY fld_team_score DESC;