It was for concatenating the 2 fields into one. But Dave answered my
question.
Thank you,
Trace
----- Original Message -----
From: Jerry Johnson
To: CF-Talk
Sent: Tuesday, May 28, 2002 1:04 PM
Subject: Re: Query question
What are you trying to get?
1. a query with all the titles from pages added to all the names from
categories?
2. a single field that concatenates the title and the name together?
3. something I'm not seeing?
Jerry Johnson
>>> [EMAIL PROTECTED] 05/28/02 02:53PM >>>
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
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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
