Problem with sql-statement

mreder

Hi,

I have a problem with a sql-statement. I use the Design Engine API.

In the statement there are matched two tables with a same entryname, e.g.

SELECT table1.name as value1, table2.name as value2 FROM table1, table2 WHERE table1.id = table2.tab1_id

The report is still generated sucessful, but if I want to open the report as maybe a HTML-resource, then I get a message like that:

---

The following items have errors:

Table table:
+ Column binding "value2" has referred to a data set column "value2" which does not exist.

---

If I take an other value coloum from the table, maybe "SELECT table1.name as value1, table2.id as value2 FROM table1, table2 WHERE table1.id = table2.tab1_id" it works fine. Then Birt use "name" and "id", I think there are no conflicts because of two equal coloumnames. ???

I don't understand that. Why i can't use alias-names? Or I am wrong?

mwilliams

Hi mreder,

Can click on the '+' sign to expand the error and attach the entire thing?