At 08:58 06.11.2002, Steve Jackson said:
--------------------[snip]--------------------
>Joins. Cool. Never heard of them before now but have started
>experimenting with them.
>What does this error mean?
>
>Error: cannot select orderid
>select orderid from orders, email where orders.orderid = email.orderid
>and email.checked='no'
>Column: 'orderid' in field list is ambiguous
--------------------[snip]--------------------
In this case both tables (order and email) have a column named orderid. The
select part pf your statement needs to specify the table name or alias
where the orderid field should be taken from:
select orders.orderid from orders, email where orders.orderid = email.orderid
and email.checked='no'
--
>O Ernest E. Vogelsinger
(\) ICQ #13394035
^ http://www.vogelsinger.at/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
