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 innerjoined as
select 1 as id, 'TEST' as productcode, 'TEST' as Brand, 'TEST' as product, 'TEST' as size union all
select 2 as id, 'TEST' as productcode, 'TEST' as Brand, 'TEST' as product, 'TEST' as size union all
select 3 as id, 'TEST' as productcode, NULL as Brand, 'TEST' as product, 'TEST' as size union all
select 4 as id, '' as productcode, '' as Brand, '' as product, 'TEST' as size union all
select 5 as id, 'TEST' as productcode, 'TEST' as Brand, 'TEST' as product, 'TEST' as size
SELECT productcode, Brand, product, size
FROM innerjoined
WHERE productcode <> '' AND
Brand <> '' AND
product <> '' AND
size <> '';
productcode Brand product size
TEST TEST TEST TEST
TEST TEST TEST TEST
TEST TEST TEST TEST
select *
from innerjoined
id productcode Brand product size
1 TEST TEST TEST TEST
2 TEST TEST TEST TEST
3 TEST null TEST TEST
4 TEST
5 TEST TEST TEST TEST
delete i from innerjoined i
where productcode = '' or productcode is null or
brand = '' or brand is null or
product = '' or product is null or
size = '' or size is null;
select *
from innerjoined
id productcode Brand product size
1 TEST TEST TEST TEST
2 TEST TEST TEST TEST
5 TEST TEST TEST TEST