How to create relationship between two tables, is primary key necessary for both tables?

you can create the foriegn key relationship as below

Hi,

Any one table should have unique key.

To link the DB read this

hi kanhialal ,
               I think,  its depend on your design and relationship, if your design dont want PK then rethink your design because what is point in putting identicle records in table...it will create problem even for joins......enev you cant give any indexes on table.
i thibk there are very few cases where PK is not needed like temp tables for loading bulk data...



Thanx,
Pravin.