How to create link table?

[#1]

Hi All,

I have two tables, I want to use link table to avoid syn key. How to do it?

Orders:

OrderId, LocaleId

Revenue:

OrderId, LocaleId, Amount

Thanks in advance.

[deepakk · Accepted solution]

HI,

If you have multiple fields to link betwen the two table then you can composite key to avoid the syn key.

eg:

(OrderId & LocaleId ) as Key in bothe fields and comment Orderid and localeId in one of the table.