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
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
