SQL DELETE with subquery

1

Hi,
I try to delete a record from a table by using a subquery but getting an error message.
here is the query below:
DELETE FROM invoices
WHERE client_id =(
SELECT client_id
FROM clients
WHERE name=‘Yadel’
);

the error message is :operand should contain 1 column(s)

2

Your query is incorrect it should read as below you need to use IN operator

DELETE FROM invoices
WHERE client_id IN (
SELECT client_id
FROM clients
WHERE name=‘Yadel’
);