hi john try aliasing the value you want to pull out, there is a way which will negate the need to name all the columns you want to select, but I can't remember it off the top of my head. The code below should work, let me kow if you have any problems
Mark <cfquery name="getRep" datasource="#session.datasource#" dbserver="#session.dbserver#"> SELECT b.total, d.total AS second_total 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> <cfoutput>#getRep.second_total#</cfoutput> -----Original Message----- From: John Gedeon [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 01:21 To: CF-Talk Subject: Two tables same column name? 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;" ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
