aliases not work when follow table name

[subern]

select a.A, concat(a.B1, b.B2) as res

from test as as a

inner join test b

using A

where a.B1 < b.B2;

it doesn't work.and note:  Expected USING or ON  

[man...@gmail.com]

Yes, table aliases (correllation names) are not supported right now.

понедельник, 25 июля 2016 г., 11:20:40 UTC+3 пользователь subern написал:

[Tima Ber]

When I joined the two tables, I can somehow distinguish between columns with the same name?

[man...@gmail.com]

You need to do JOIN subquery with subquery and set different aliases for that columns inside.

вторник, 26 июля 2016 г., 16:49:38 UTC+3 пользователь Tima Ber написал:

[Tima Ber]

Thanks, it works

[rasmus]

Will aliases be supported in the near future?

[man...@gmail.com]

We plan to add support in 2016.

[dmitry skripnikov]

Hello!
Are table alases supported now? it is crucial for me because Hibernate always uses aliases.

воскресенье, 18 сентября 2016 г., 4:22:03 UTC+3 пользователь man...@gmail.com написал: