What is Best way to join Multiple tables?

[bharani8]

Hi Experts,

What is the best way to join tables when i have more than 1 common fields in each table..

Eg., I have 6 different tables and i have 2-3 common fields in each table..

[sasiparupudi1]

Concatenate the fields together to create a composite key

[sunny_talwar]

Explicit join is an option unless you don't want to join....  If you don't want to explicitly join them, you have to the option of creating a Link table

Concatenate vs Link Table

[PrashantSangle]

Why do you want to join. Create key on the basis of granularity of the all tables and kept it them on associataion. Rename all fields which create synthetic key.

If possible share your table structure so that we can provide more accurate solutions..

Regards,

[shiveshsingh]

You can use concatenate function