Greetings:
RE: mySQL query help please
INSERT INTO Customer_Equipment SELECT Customer.ID, Server_ID,
Configuration, Equipment_Type, Group_ID, Location, Rack_Location,
Network_Status_Name, Creator_ID, Primary_IP_Address FROM
Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 5,4) =
Customer.User_ID;
The select statement works perfectly, but when I try to combine the select
statement with an INSERT INTO statement (I've done this in the past), I get
the error message:
ERROR 1066: Not unique table/alias: 'Customer_Equipment'
What does this error message mean, and how should I accomplish my insert
into statement so I can use the results of the select statement above?
Thank you.
________________________________________________
Peter M. Perchansky, President/CEO
Dynamic Net, Inc.
Helping companies do business on the Net
420 Park Road; Suite 201
Wyomissing PA 19610
Non-Toll Free: 1-610-736-3795
Personal Email: [EMAIL PROTECTED]
Company Email: [EMAIL PROTECTED]
Web: http://www.dynamicnet.net/
http://www.manageddedicatedservers.com/
http://www.wemanageservers.com/
________________________________________________
---------------------------------------------------------------------
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
