How to avoid $Syn Table?

[#1]

Hi,

I have four SQL queries serving for four different sub problems. When I load data, it will automatically create $syn table. However, I want to remove them. I used "Nonconcatenate Select", it did not avoid the implicit concatenate. Can anyone help me here?

Thanks

Danni

[#2]

use an alias to the fields or the qualify/unqualify function.

[#3 · Accepted solution]

Hi Danni,

to avoid syn keys:

please give Qualify *; before the tables,

after that if u want to unqualify any field to map those tables. Please give Unqualify Field_name1,......;

Hope its very useful.

Thanks & Regards,

Sri

[#4]

Thanks Sri and mOngkz. I successfully avoid the $syn table.

Thanks once again!

Danni