add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tab_Def(
col_1 INT,
col_2 varchar(10) );

insert into tab_Def values
(101,'ABC'),
(102,'ABC'),
(101,'XYZ');

CREATE TABLE tab_Prod(
col_1 INT,
col_2 varchar(10) );

insert into tab_Prod values
(-101,'ABC'),
(102,'ABC'),
(-101,'XYZ');



Records: 3  Duplicates: 0  Warnings: 0

Records: 3  Duplicates: 0  Warnings: 0
select td.col_1,
td.col_2,
tp.col_1
from tab_Def td
inner join tab_Prod tp on td.col_2=tp.col_2
where tp.col_1 = concat('-',td.col_1);
col_1 col_2 col_1
101 ABC -101
101 XYZ -101
select td.col_1,
td.col_2,
tp.col_1
from tab_Def td
inner join tab_Prod tp on td.col_2=tp.col_2
where td.col_1 <> tp.col_1
and td.col_1 = REGEXP_REPLACE(tp.col_1, '[^0-9]+', '');
col_1 col_2 col_1
101 ABC -101
101 XYZ -101