You need to qualify which table you are pulling the id from, since you are
using two different tables in your query...
<CFQUERY NAME="GetNumber" datasource="OIMPROD">
SELECT Max(tablename.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>
----Original Message Follows----
From: "James Taavon" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Subject: SQL JOIN
Date: Fri, 25 Aug 2000 10:44:41 -0400
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.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
------------------------------------------------------------------------------
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.
