synthetic key

[ssriramin19]

     Hi,

                I have two tables A and table B. There are over 100 columns in table A and table B. The column names in table A and table B is same. So synthetic key is formed.How to remove the synthetic key in this case?

Can anyone help me in avoiding the synthetic key ?

Thanks

Sriram

[#2]

hi,

you need to rename the columns of either of the tables so that except for the primary key, none of the columns have same names.

rgds,

mrunmayi

[er_mohit]

Try this

Doing  Join  between two tables

hope it helps

[#4]

Hi ,

   Try to use Qualify Keyword.

Qualify * ;

UnQualify   primaryField Name ;

Regards

Yusuf

[sivarajs]

Just do a concatenation between the tables

[#6]

You can remove synthetic key by the following ways.

1.     using JOIN  between two table

2.     using CONCATENATE between two table

3.     rename fieldnale in both table except primary key

4.     using Qualify