View Full Version : Creating Relationship between tables in SQL Server 2000

Jul 28th, 2006, 08:01 PM
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!

Aug 5th, 2006, 03:49 AM
did you mean you want to join the 2 tables???

try inner join in your sql syntax