Help w/Error Message
| From: | Toni Barskile | Date: | Fri, 06 Apr 2001 14:04:25 +0000 |
| Subject: | Help w/Error Message | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-47439@lists.php.net to get a copy of this message | ||
Hi:
Can someone please explain the following error message?
ERROR 1052: Column: 'compid' in field list is ambiguous
Here's my mySQL statement:
$sql="SELECT fname, lname, compid, status, dept, room, bldg, phone,
ticket_num, compid, date_rpt, request_type, hardware, model, dci,
dci_num,software_type, software_pkg, problem, comments, entered_by
FROM users, tickets
WHERE users.compid = tickets.compid
ORDER BY lname";
Thanks in Advance
Toni
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com