On 11/10/06, Matthew Terenzio [EMAIL PROTECTED] wrote:
I suppose I should have named things differently but is there a way to
join two tables with a bunch of identical column names and rather than
explicitly alias each column just use some sort of wildcard like:
SELECT tablename.* AS alias.*
I suppose I should have named things differently but is there a way to
join two tables with a bunch of identical column names and rather than
explicitly alias each column just use some sort of wildcard like:
SELECT tablename.* AS alias.*
OR do I have to name each column like:
columnname
I don't know what your query or aliases have to do with joins, but if
you want to join two tables on all fields with the same name, you can
do a NATURAL JOIN.
Have a nice day,
On Fri, Nov 10, 2006 at 05:17:12PM -0500, Matthew Terenzio wrote:
I suppose I should have named things differently
On Fri, 2006-11-10 at 23:34 +0100, Martijn van Oosterhout wrote:
I don't know what your query or aliases have to do with joins, but if
you want to join two tables on all fields with the same name, you can
do a NATURAL JOIN.
Have a nice day,
On Fri, Nov 10, 2006 at 05:17:12PM -0500,