Is it possible to join two files in SQL as follows:
a.Cust_type_Buyer_or_Seller value "B" or "S"
b.cust#_buyer example value 123
b.cust#_seller example value 789
Is it possible to join FileA to FileB where a.Cust# will join with
b.cust#_buyer ONLY when a.Cust_type_Buyer_or_Seller = "B", and also join
with b.cust#_seller ONLY when a.Cust_type_Buyer_or_Seller = "S" ?
Clear as mud?
Hoping this can be done with a CASE statement?
Or maybe with two separate queries?
Thanks in advance!
This outbound email has been scanned for all viruses by the MessageLabs
For more information please visit http://www.symanteccloud.com
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives