Creating Relationship between tables in SQL Server 2000

[chelvis]

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]

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