Dear Experts
create table PRDT_MAST
(
PRDT_CODE varchar(5),
PRDT_STATUS VARCHAR(5)
);
INSERT INTO PRDT_MAST VALUES('AB01','000');
INSERT INTO PRDT_MAST VALUES('CD01','999');
INSERT INTO PRDT_MAST VALUES('EF01','000');
INSERT INTO PRDT_MAST VALUES('ZA01','999');
CREATE TABLE CUST_PRDT
(
CUST_PRDT_CODE varchar(5),
CUST_PRDT_STATUS VARCHAR(5)
);
insert into CUST_PRDT values('AB01','000');
insert into CUST_PRDT values('CD01','999');
insert into CUST_PRDT values('EF01','000');
create table recon
(
recon_prdt varchar(5),
recode_code varchar(10)
);
if 000 in PRDT_MAST and 000 in CUST_PRDT then update as 102 in recon_code to the respective prdt_code in recon table
similaryly if 999 in PRDT_MAST and 999 in CUST_PRDT then update as 202
Desired result
select * from recon
recon_prdt recon_code
AB01 102
CD01 202
EF01 102
ZA01 202
Please help experts