When I execute this in mysql it works fine, but when I execute it on a web
page it gives a "Not Unique table/alias 'sporttable'
I would expect errors if 'playerpayment' was in my FROM clause but as you
can see it is not.
Note my example:
INSERT INTO playerpayment ( Family_ID, Player_ID, Player_Fee, Sport_ID )
SELECT playertable.Family_ID, playertable.pid, sporttable.Category_1_Fee,
sporttable.sid
FROM sporttable, playertable
WHERE sporttable.sid = playertable.SportRegistered AND
(((playertable.Grade)>=sporttable.Category_1_Grade_Start And
(playertable.Grade)<sporttable.Category_2_Grade_Start))
GROUP BY playertable.Family_ID, playertable.pid, sporttable.Category_1_Fee,
sporttable.sid;
mysql running on W2K-Advanced
version: 3.23.33
TIA
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
(mail filter bologna: sql,database,query)
---------------------------------------------------------------------
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