RE: table join

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Wed, 1 Feb 2006 15:18:20 -0600
Message-ID: <A6801E8A03316A4DA597866F77A013F7059CA0E7@irv2kexch01.tx.bg.corp>

thanks for all of you who had answered or are answering my email.

-----Original Message-----
From: Jim Silverman [mailto:jsilverman_at_Solucient.com] Sent: Wednesday, February 01, 2006 3:14 PM To: Roger Xu; Oracle-L_at_Freelists. Org (E-mail) Subject: RE: table join

You concatenate two columns in the WHERE clause the same way you do so in the SELECT clause:

...

where A.Lastname || A.Firstname = B.Lastname-Firstname

...

I'm not sure if I have the column names exactly correct, but you should get the idea.

Note that this expression in the WHERE clause will likely preclude the use of indexes on either of the columns in table A, unless you use function-based indexes.

Jim Silverman
Senior Systems Database Administrator
Solucient, LLC
Telephone: 734-669-7641

FAX:            734-930-7611
E-Mail:         jsilverman_at_solucient.com 

	From: oracle-l-bounce_at_freelists.org [ mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu

Sent: Wednesday, February 01, 2006 4:07 PM To: Oracle-L_at_Freelists. Org (E-mail)
Subject: table join

Table A:

Lastname (Mike)

Firstname (Johnson)

Phone(323-442-5678)

Table B:

Lastname-Firstname(MikeJohnson)

StreetAddress(1242 Main St.)

Zip(76222)

How do I join these two tables?

select B.Lastname-Firstname,A.Phone,B.StreetAddress,B.Zip

from A,B

where B.Lastname-Firstname = A.Lastname + A.Firstname

Basically, how to concatenate two fields in the where clause?

Thanks,

Roger

This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material.

This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support_at_dp7uptx.com.

This message is a private communication. It may contain information that is confidential and legally protected from disclosure. If you are not an intended recipient, please do not read, copy or use this message or any attachments, and do not disclose them to others. Please notify the sender of the delivery error by replying to this message, and then delete it and any attachments from your system. Thank you,
Solucient LLC
(eXclaimer 4x)

For technical support please email tech_support_at_dp7uptx.com or you can call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email Security System.

This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support_at_dp7uptx.com.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 01 2006 - 15:18:20 CST