Duplicate column name error

[Serg]

When I trying execute the query below I get the following error:
“Duplicate column name "DEPARTMENTID" …”

Query:
select * from (select department.*, employee.* from department,
employee where department.departmentid=employee.departmentid)

Tables “department” and “employee” has the common column
“DEPARTMENTID”.
It seems to me that the query is correct, because the inner subquery
works.

Can you support such query?

[Sergi Vladykin]

Instead of wildcards you should use explicit column list with unique
aliases in your subquery.

[Thomas Mueller]

Hi,

Maybe this will also work in your case, because "natural join" doesn't
duplicate columns:

select * from (select * from department natural join department);

Regards,
Thomas

> --
> You received this message because you are subscribed to the Google Groups "H2 Database" group.
> To post to this group, send email to h2-da...@googlegroups.com.
> To unsubscribe from this group, send email to h2-database...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
>
>