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
