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
invoices.cust_id=custome
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
invoices.cust_id=customers
