I think you should use this statement. I did not try it.
DELETE FROM hinvoice h
USING dinvoice d
WHERE h.nof=d.nof
AND h.tgl < '2002-09-01';
Regards
Stephan
-----Original Message-----
From: MySQL [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 13, 2002 9:25 AM
To: List
Subject: deleting data from mater-detail table
dear all,
hi, i have a question that bother me in last few days and would you help me
to solve it, please. i have a master-detail table: hinvoice and dinvoice.
the table structure of those two table shown as below :
create table hinvoice (
nof varchar(7) not null,
noso varchar(7),
tgl date,
amountpaid double(16,2),
status char(2),
primary key(nof)
)
create table dinvoice (
nof varchar(7),
code varchar(7),
qty int,
)
field "nof" is the join field. i intended to delete some invoices for
certain date, for example every invoice that older than 1st Sept 2002. can i
give a single query to finish this job? i can select this with
$ select h.nof, h.tgl, d.code, d.qty from hinvoice h, dinvoice d where
h.nof=d.nof where h.tgl < '2002-09-01';
query. but how can i delete them ?
thank you for your attention ..
yours,
toni
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
