Dusan.
- Original Message -
From: "Tomas Rasek" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, December 21, 2005 11:12 AM
Subject: Re: Delete query problem
What about
DELETE master_tbl,detail_tbl FROM master_tbl LEFT JOIN detail_tbl ON
master_tbl.ID=detail_tbl.ID WHERE .
T.R.
On 21/12/2005, Dušan Pavlica wrote:
> Hello,
> I have master-detail tables and I would like to delete in one
> statement master record and all detail records but not every master
> record has details. MySQL versions 4.1.10 and higher. Could someone
> help me, please, to create such a query?
>
What about
DELETE master_tbl,detail_tbl FROM master_tbl LEFT JOIN detail_tbl ON
master_tbl.ID=detail_tbl.ID WHERE .
T.R.
Dušan Pavlica napsal(a):
Hello,
I have master-detail tables and I would like to delete in one statement master record and all detail records but not every master rec
