I have a query where i join two tables. and both tables have a field which are titled the same but each table has a different value. is there a way for pulling the two different values out in cold fusion or do i have to use multiple selects??
<cfquery name="getRep" datasource="#session.datasource#" dbserver="#session.dbserver#"> SELECT * FROM trip_flow_breakdown b, trip_flow_data d WHERE b.wid = #attributes.wid# AND b.fid = #attributes.fid# AND b.id = #attributes.id# AND d.wid = #attributes.wid# AND d.fid = #attributes.fid# </cfquery> the field i want to get is total but if i use <cfoutput query="getRep">#total#</cfoutput> i only get the value of the first table in the from clause. any one have a solution? <>< Proverbs 3:5 "Trust in the Lord with all your heart and lean not on your own understanding;" ______________________________________________________________________ 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
