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
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
