Re: Join - Two Columns with the same name
| From: | Jochem Maas | Date: | Thu, 13 Apr 2006 22:38:51 +0000 |
| Subject: | Re: Join - Two Columns with the same name | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-233951@lists.php.net to get a copy of this message | ||
Kevin Murphy wrote:
This is probably basic, but I can't seem to find the answer. Is there a way to specify in a join a specific column when the two tables have columns with the same name? Something like: $row['table1.id'] vs $row['table2.id']yes. http://dev.mysql.com/doc/ is a good place to starting reading up on SQL JOIN syntax.