Join tables

[#1]

Hello All,

I need to know the simple process of joining 3 tables:

table A --------------> table B<----------------Table C

And I don't want to have any Sync table.

Thanks,

[spsrk_84]

Hi,

Create composite key in each table if you have more than one key in common between the three tables.Such that u can elminate the Synthetic keys/tables.

Thanks

Shiva

[#3]

Here is the case:

I select my table from database and I create the composite key in the same Select comand ,Or I have to create a linked table?

Thanks for your help?

[#4]

When I create a composite key I get an error message like this:

SQL ###f- SqlState :$1000,Errorcode:923 ....................... keyword was not found where expected SQL select.....

Any Idea?

[MayilVahanan · Accepted solution]

Hi

Use

In load statement, create the composite key or create the common name for two tables

Load * , compositekey;

Select * from tablename;

[#6]

Thanks,

It worked....