CREATE TABLE tab_risk (
prod_id NUMBER(10),
prod_name VARCHAR2(30),
prod_filter VARCHAR2(30),
constraint pk_tab_risk primary key (prod_id)
);
insert into tab_risk values(1,'a','Falcon');
insert into tab_risk values(2,'b','Cars');
insert into tab_risk values(3,'c','Powerpoint');
insert into tab_risk values(4,'d','Zone');
CREATE TABLE ref_filter (
add_in_filter VARCHAR2(30)
);
insert into ref_filter values('Powerpoint');
insert into ref_filter values('Word');
insert into ref_filter values('Email');
I need to append the ref_filter data to a particular prod_id. But I am wondering how this can be done or is this possible or not? Like for prod_id 1 currently, prod_filter is 'Falcon' but when I select
prod_id 1 it should give me 'Falcon', 'Powerpoint', 'Word', and 'Email'. And likewise for prod_id 2 and so on. Is there any way to achieve this?