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?