Let me elaborate want i want to do.

I have a table

create table mastercompetency

(program varchar(10),

SKUgroup varchar(10),

competencyname varchar(10))

insert into mastercompetency values('DIRECT','SKG1','GOLD 1')

insert into mastercompetency values('DIRECT','SKG1','GOLD 2')

insert into mastercompetency values('EA','SKG2','GOLD 1')

insert into mastercompetency values('EA','SKG1','SILVER 1')

insert into mastercompetency values('DIRECT','SKG1','GOLD 1')

I need to process the records based on above competency which should follow the below criteria.

It should consider (GOLD1 and GOLD 2) OR SILVER 1 kind of condition for the input data in order to pass and that competencyname which be any of either AND/OR condition.

What will be my table design for this.