MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table innerb (pcode varchar(7), brand varchar(10), Pdescription CHAR, Size VARCHAR(10), barcode int);
insert into innerb values
('0101102', 'TEST', 'A', '2kg', 123),
('0806102', 'TEST', 'B', '2kg', 1234)
create table wms (barcode int)
insert into wms values
(1234)
CREATE VIEW innerb_comma AS
SELECT CONCAT(Pcode, ',') AS Pcode,
       CONCAT(Brand, ',') AS Brand,
       CONCAT(Pdescription, ',') AS Pdescription,
       CONCAT(Size, ',') AS Size,
       CONCAT(Barcode, ',') AS Barcode
FROM innerb
WHERE NOT EXISTS (SELECT * FROM wms WHERE barcode = innerb.barcode) 
  AND Pcode like '%102';
select * from innerb_comma


Pcode
Brand
Pdescription
Size
Barcode


0101102,
TEST,
A,
2kg,
123,