All Forums Analytics
nichunchun 6 posts Joined 01/09
21 Jan 2009
UDFCALLNAME, date problem

Hi, I have a query:Pseudocode is the following.select a.*, b.datefrom 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 773 posts Joined 04/08
21 Jan 2009

Hello,Try as following:SELECT "date" FROM Table1;SELECT a."date" FROM Table1 a;HTH.Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

nichunchun 6 posts Joined 01/09
22 Jan 2009

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

You must sign in to leave a comment.