Forum Discussion
Assign a value based on two columns of criteria that each contain wildcards?
I am trying to assign a sales code to each sales line based on the customer and/or product code. So, I want to assign a sales code based on either 1. the customer number, 2. the product code or 3. bo...
select * from lookup_in_keywords;
select * from lookup_in;
select a.*,b.F_C from lookup_in_keywords a left join lookup_in b where a.f01 like b.F_A or a.f02 like b.F_B;
how about this by sql?