Search results

  1. B

    SQL DDL Help. Problem with dates

    Hi guys. I've just entered this SQL to insert data into another table. INSERT INTO OldOrders SELECT * FROM Orders WHERE OrderID IN (Select Orders.OrderID From Orders INNER JOIN OrdersDetails ON Orders.OrderID=OrdersDetails.OrderID WHERE (Orders.Date Between '01/01/2008' And '01/02/2009') )...
  2. B

    SQL DDL Help!!!!!!!!

    I want to practice making queries but it doesn't seem to work. I can do basic SQL, but SQL DDL doesn't work. Same applies for DML although I am following the correct steps. Please help. For example CREATE TABLE. This is what I have done thus far: CREATE TABLE NO ORDERS (Sname varchar(20)...
  3. B

    Need some help Urgent

    Hi. I need some help for my online shopping table prototype. I want to be able to allow data to be entered which shows that customers can buy the same products. I can't do this because the Product ID is a primary key in the product table. So if someone wants to buy a bread say, then the database...
Back
Top Bottom