删除顾客表(customers)中没有下过订单的顾客信息
提示:请使用DELETE语句作答。
delete
from customers
where CustomerID not in (
select CustomerID
from orders
)
删除顾客表(customers)中没有下过订单的顾客信息
提示:请使用DELETE语句作答。
delete
from customers
where CustomerID not in (
select CustomerID
from orders
)