hi can anyone help me please ???? i have two tables
and for one invoice record there are many visainfo records so i need a query to delete an invoice record and all the related records from the visainfo table..
delete from invoice,visainfo
where invoiceno is the key field in the invoice table