Ahhhh, I'll try that.
Thanks
Jim Ray
Delta Program NT Administrator
The Boeing Company
(714) 896-2038
Email: [EMAIL PROTECTED]
Website: http://deltaweb.lgb.cal.boeing.com/
-----Original Message-----
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 17, 2000 6:33 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Query a Query
> I thought about this one as a possible solutions. The problem is, I have 2
primary keys
> and I haven't been able to locate any examples of how to use two keys.
Jim,
You can do this by concatenating the two values - if they're numeric, you'll
have to convert them to a character datatype first. The syntax of the actual
function calls for concatenation and type conversion depends on your DBMS,
but something like
WHERE CONCATENATE(TO_CHAR(Primary_Key_1), TO_CHAR(Primary_Key_2))
IN (SELECT CONCATENATE(TO_CHAR(Primary_Key_1), TO_CHAR(Primary_Key_2))...)
Nick
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.
