UDFCALLNAME, date problem

[nichunchun]

Hi, I have a query:
Pseudocode is the following.
select a.*,
b.date
from table a
join table b
on condition

show " Syntax error, expected something like an 'UDFCALLNAME' keyword between '.' and the 'date' keyword "

select date from table b. result show date works as a function instead of a column name.

Anybody knows how to fix it?

[Adeel_Chaudhry]

Hello,

Try as following:

SELECT "date" FROM Table1;
SELECT a."date" FROM Table1 a;

HTH.

Regards,

Adeel

[nichunchun]

Yeh! It works. The forum is really useful! Thanks a lot Adeel!!!