from: "Stone, Joel" <Joel.Stone@xxxxxxxxxx>
subject: SQL: how to join two files using field depending on values
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!