RE: table join
- From: "Ken Naim" <kennaim@xxxxxxxxx>
- To: <roger_xu@xxxxxxxxxxx>, "'Oracle-L@Freelists. Org (E-mail)'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 1 Feb 2006 15:11:47 -0600
the answer is just do it exactly like you said
a.lastname||a.firstname=b.lastname-firstname
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Roger Xu
Sent: Wednesday, February 01, 2006 3:07 PM
To: Oracle-L@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@xxxxxxxxxxxx
Other related posts:
