Hello, I am new to mysql - past the very basics - you may see a few silly
questions - here is the first.
I have a DELETE statement:
delete bond_master,bond_data from bond_data where
bond_master.cusip=bond_data.cusip and bond_master.maturity <= "2002/02/15";
That has syntax errors. I am issuing this at the mysql command prompt - a
little background:
two tables:
bond_master (fields: cusip, maturity, rating)
bond_data (field: cusip, date, delta)
common field:
cusip
goal:
to delete all the records in the bond_data table where the maturity date
is before a certain date
so I tried the above select to no avail in many different combinations.
Any help would be appreciated.
Thanks,
Andrew
---------------------------------------------------------------------
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
