Merlin <[EMAIL PROTECTED]> wrote on 10/09/2005 01:31:17 PM:
> Hi there,
>
> I am wondering if there is a possiblity to delete rows in more than one
> table with one query.
>
> At the moment I am doing this:
>
> I do have at the moment 3 querys!:
># get table1_id
>SELECT table1_id
>
Rhino wrote:
- Original Message -
From: "Merlin" <[EMAIL PROTECTED]>
To:
Sent: Sunday, October 09, 2005 1:31 PM
Subject: deleting rows in 2 tables
Hi there,
I am wondering if there is a possiblity to delete rows in more than one
table with one query.
At the m
- Original Message -
From: "Merlin" <[EMAIL PROTECTED]>
To:
Sent: Sunday, October 09, 2005 1:31 PM
Subject: deleting rows in 2 tables
> Hi there,
>
> I am wondering if there is a possiblity to delete rows in more than one
> table with one query.
>
Hi there,
I am wondering if there is a possiblity to delete rows in more than one
table with one query.
At the moment I am doing this:
I do have at the moment 3 querys!:
# get table1_id
SELECT table1_id
from ...
WHERE ID = ...
# delete dependent entry
DELETE
FROM $DB.$T5
