Hello.
I am evaluating two columns under the same name in two different tables.
The error I got, "A reference to column "ID" is ambiguous" was expected.
My code is below. Can I do and INNER JOIN two resolve this error and
retrieve the correct value? If so , how? I don't have much practice with
using JOIN.
Thanks in advance!
<CFQUERY NAME="GetNumber" datasource="OIMPROD">
SELECT Max(id) AS MaxOfID
FROM db2admin.tb_assigned,db2admin.tb_complete
where db2admin.tb_assigned.id = db2admin.tb_complete.id
</cfquery>
<CFSET NextPONum = getnumber.MaxOfID + 1>
<cfoutput query="GetNumber">
#NextPONum#
</cfoutput>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
