...

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



chelvis
07-28-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!

prototyp3
08-05-2006, 03:49 AM
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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum