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
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.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
