MySQL 8.0

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

create table t1 (
  shipment_type varchar(20)
);

insert into t1 values
('Prime');

create table t2 (
  shipment_type varchar(20)
);

insert into t2 values
('Prime'),
('Non-Prime');

Records: 2  Duplicates: 0  Warnings: 0


SELECT t2.*
FROM t2
INNER JOIN t1 ON t1.shipment_type = t2.shipment_type  OR t1.shipment_type = 'All';


shipment_type


Prime


delete from t1;

insert into t1 values
('All');
SELECT t2.*
FROM t2
INNER JOIN t1 ON t1.shipment_type = t2.shipment_type  OR t1.shipment_type = 'All';


shipment_type


Prime

Non-Prime