You need to use a union join. Adam.
> -----Original Message----- > From: Trace [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 28, 2002 2:36 PM > To: CF-Talk > Subject: Query question > > > Is there a way to refer to 2 fields in one query with the same name? > > I have a field called "title" in table "tbl_Pages" and a > field called "Name" > in table "tbl_Categories" > > <cfquery name="getHyperlinks" datasource="#ds#"> > SELECT tbl_Pages.title AS hyperlink_title, > tbl_Categories.Name AS hyperlink_title > FROM tbl_Pages, tbl_Categories > </cfquery> > > Obviously the above gives me the error: Duplicate output alias > 'hyperlink_title' > > Is there a way around this? This is for cf 4.5. > > Thanks, > Trace > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
