Re: Join table with clashing fieldnames
| From: | clive | Date: | Wed, 08 Nov 2006 13:40:52 +0000 |
| Subject: | Re: Join table with clashing fieldnames | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-244371@lists.php.net to get a copy of this message | ||
clive wrote:
1. This is a SQL question and not a php one. 2. select a.name as aname, b.name as bname, c.name as cname where a.id=b.id and a.id=c.id from a,b,coops beer gone to my head, the from should come before the where as most of you I'm sure know.