id (primary key)
id (foreign key)
Ho can I delete let's say the id=300 from t1 and all the rows where id=300 from t2?
this does not work:
delete from t1,t2 where t1.id=t2.id and t1.id=300
it says: SQL Error: ORA-00933: SQL command not properly ended
This post has been edited by livium: 06 October 2010 - 09:02 AM