-- table name prefix in result set after join --
| From: | Matt Friedman | Date: | Sat, 23 Nov 2002 15:18:29 +0000 |
| Subject: | -- table name prefix in result set after join -- | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23613@lists.php.net to get a copy of this message | ||
Is there a way in SQL to have the column names prefixed by the table
name in a result set after a join?
Table A has column col1 and table B has columns col2 and col3
After the join I want the result set to have columns named
A.col1 B.col2 B.col3
Such that I can tell from which table each column came from.
Is this possible?
Matt Friedman