Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
use an alias to the fields or the qualify/unqualify function.
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
Thanks Sri and mOngkz. I successfully avoid the $syn table.
Thanks once again!
Danni