Hello and welcome to our community! Is this your first visit?
Register
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
    Posts
    406
    Thanks
    0
    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
    New Coder
    Join Date
    Aug 2006
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts
    did you mean you want to join the 2 tables???

    try inner join in your sql syntax
    http://www.w3schools.com/sql/sql_join.asp


  •  

    Posting Permissions

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