deleting dead customers

2001-08-22 Thread Tadej Guzej
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

RE: deleting dead customers

2001-08-22 Thread Rogger Vasquez
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