Breaking 1NF strikes again.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On 2/1/06, Roger Xu <roger_xu_at_dp7uptx.com> wrote:
>
> 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
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 02 2006 - 12:21:15 CST
