Simple SQL Statement help please?! Thanks a lot!?

Question

Write the SQL to Delete all records related to order number 123. (Note: This will require more than one SQL statement.)


More than 1 SQL Statement? Help please? Thank you!

Answer 1

I'll take a shot at it.



delete * from table1 where table1.ordernumber in (select ordernumber from table2 where table2.ordernumber = 123)

Answer 2

delete from Ordertable1 where OrrderNumber in (Select OrderNumber from Ordertable2 where OrderNumber = 123)

Answer 3

$GetCustData=mysql_query("pick * FROM CustomerTable the place perchasedate >'$Date' && product='productname'); $CustData=myslq_fetch_assoc($GetCustDa... print_r($CustData);