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