When you write the sql statement you have to use the AS keyword to rename
one of the columns
Select table1.colname, table2.colname as colname_new
Then, of course, when you output, you use the correct alias.
#queryname.colname# #queryname.colname_new#
> -----Original Message-----
> From: Michael She [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 29, 2000 9:52 PM
> To: CF-Talk
> Subject: Retreiving Query Columns
>
>
> If I'm joining multiple tables together and they have columns
> with the same
> name, how do I distinguish between them?
>
> I've tried: #queryname.table.column_name# but this doesn't
> seem to work.
>
> Thanks.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists