PowerServer is correct and PB is wrong.  Also, PB uses table_columnname when creating the dw via the IDE, so PB is only wrong with syntaxfromsql.

this is my submission to appeon on this subject: 

https://www.appeon.com/standardsupport/search/view?id=3860

it should always return table_columnname - if you have 2 tables with the same column name then you have no clue which table it is linked to without the prefix.   it needs to be consistent for every column it creates.  Even with only 1 table in use it would be easier if it consistent and always used  table_columnname. 

The way it is now makes it difficult to know when to use just the column name and when to use both regardless of PS vs PB.  

What i do is to check if a column exists via describe - i use tablename_columnanme.  if it exists, then i know to use the prefix and if it doesn't i don't....

Hello,

I am using pb2019 R3 version and I have the same problem.

I use multiple databases and I only have the problem in one of them and with the owner user.

If you do the following it works OK:

SELECT TABLE1.NAME1 AS 'NAME1' , TABLE2.NAME2 AS 'NAME2' FROM TABLE1,TABLE2.

That is, if you put the aliases in quotes, the syntaxfromsql statement works correctly and when creating a datastore dynamically it does NOT 
create the fields in the TABLE_NAME way.

This leads me to think that it may be a configuration parameter user / BBDD.

do you consider any solution?



Thanks

What version of PowerServer are you using?

My power server version is PowerServer (PB Edition) 2020 Build 2703.00

Hi Saravanakumar

Can you try your SQL like this

Select (a.field1) as field1, (a.field2) as field2, (b.field3) as field3
From  table1 a
Join    table2 b
On     b.key = a.key
Where somefield = somevalue ;

Is your datawindow sql in 'graphic' or 'syntax' mode?

I found this: https://docs.appeon.com/ps2021/bk06ch03s01s02.html

But it describes the problem vice versa!?

syntax