Query Problem


Query Problem

I have a query where I have used Alias name inplace of tablenames. However when I execute the Query using "From tablename as table_Alias", it gives an error whereas when i run the same query after removing Alias, it worked fine..

Can ny1, plse help me out with the problem..

Is it the alias thing that is choking it out??

Error Message that I get is :

SELECT Failed. 3706:  Syntax error: Temporal operations are not supported on this system.

The same query seems to work well in BTEQ..


Re: Query Problem

Can you paste the query ?