RE: table join

From: Ken Naim <kennaim_at_gmail.com>
Date: Wed, 1 Feb 2006 15:11:47 -0600
Message-ID: <43e12487.3b8eda79.365c.ffffb719@mx.gmail.com>

the answer is just do it exactly like you said a.lastname||a.firstname=b.lastname-firstname

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu
Sent: Wednesday, February 01, 2006 3: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.

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

Received on Wed Feb 01 2006 - 15:11:47 CST