table join

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

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:07:14 CST