Hello!
I have two tables. One contains invoices, one contains customers.
How do I delete customers that are not linked to any invoice.
The relation is one to many (invoices -- customers).
I can select them with:
select customers.* from customers left join invoices on
Hello!
I have two tables. One contains invoices, one contains customers.
How do I delete customers that are not linked to any invoice.
The relation is one to many (invoices -- customers).
I can select them with:
select customers.* from customers left join invoices on