create view , create teable
drop view , drop table
Create view productcustomers as
Select CompanyName,ContactName,ProductID FROM Customers,orders,order_details where Customers.CustomerID=Orders.CustomerID AND Order_Details.OrderID=Orders.OrderID;
create view , create teable
drop view , drop table
Create view productcustomers as
Select CompanyName,ContactName,ProductID FROM Customers,orders,order_details where Customers.CustomerID=Orders.CustomerID AND Order_Details.OrderID=Orders.OrderID;