RE: SQL Question

[Gord Royle <GRoyle@xxxxxxxx>]

You can do this with simple SQL

select loc, add1, add2, shiploc, shipadd1, shipadd2
from tableA, TableB
where loc = shiploc

This assumes a 1 to 1 relationship.

Gord Royle

-----Original Message-----
From: Hatzenbeler, Tim [mailto:thatzenbeler@xxxxxxxxxxxxx]
Sent: Friday, March 07, 2003 4:20 PM
To: 'Midrange Systems Technical Discussion'
Subject: SQL Question


Can I do this in SQL?  I know its not the best method but my tables are
small..

I have 2 tables,  a Warehouse table and a Ship To Table...

And in each table, I have a key'd field, (location) that may have data like
STOCK, MAIN, LAB

that denotes what address to retrieve from these tables...

What I would like to do, is create a view, with a new key field, that joins
these 2 tables into 1 table, for the purpose of my query...  here is the
kicker...  the field names are not the same...  there both character
fields...
tablea
~~~~~~~~~
loc     stock
add1   4201
add2   bend, oregon

tableB
~~~~~~~~
shiploc   mm
shipadd1  3907 highland dr
shipadd2  bellingham, wa


Is this possible?  
This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review, use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.