By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Table1(
OrderID int,
CustomerID int,
IsPaid varchar(03)
);
CREATE TABLE Table2(
CustomerID int,
Cust_name varchar(255)
);
INSERT INTO Table1
VALUES
(1, 12, 'no'),
(2, 12, 'yes'),
(3, 13, 'no'),
(4, 13, 'no'),
(1, 14, 'yes'),
(2, 14, 'yes');
INSERT INTO Table2
VALUES
(12, 'John'),
(13, 'Nick'),
(14, 'Paul');
SELECT t1.customerid,
Max(cust_name) AS cust_name
FROM Table1 t1
INNER JOIN Table2 t2 using (customerid)
GROUP BY t1.customerid
HAVING Group_concat(ispaid) = "no,yes"
| customerid | cust_name |
|---|---|
| 12 | John |