Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Jun 2002
    Thanked 0 Times in 0 Posts

    Creating Relationship between tables in SQL Server 2000

    I have created a database which has the following tables:
    Customers, Orders, Products, Categories, OrderDetails, ShoppingCart.

    I have created the individual tables and set the column name (eg: orderID, orderName...) and the datasypes for them.

    How do I create the relationship between the tables with SQL Server 2000?
    I searched in google but didnt find any good tutorial.

    I think you have to first create the relationship otherwise the tables wont be updated automatically is it? For example if I update a OrderDetails table then the Orders table should update automatically etc.

    Please help!

  2. #2
    New Coder
    Join Date
    Aug 2006
    Thanked 0 Times in 0 Posts
    did you mean you want to join the 2 tables???

    try inner join in your sql syntax


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts