Every derived table must have its own alias
Posted: Fri Apr 09, 2010 2:06 pm
Hello,
i'm working with the sun report builder version 1.2.0 and have the following problem
to populate the report i use this query to a MySQL database:
SELECT "user" AS "user", "werk" AS "werk", "DTSTART" AS "DTSTART","DTEND" AS "DTEND", TIMEDIFF(TIME(DTEND),TIME(DTSTART)) AS "TIMEDIF" FROM "werktimer" WHERE "DTEND" > '2001-01-01 00:00:00' ORDER BY "werk", "DTSTART"
this query works when i open it but when i want to launch the report i get the error: Every derived table must have its own alias
can anyone help me with this?
is there an alternative to the Sun Report Builder?
thanks
Marco
i'm working with the sun report builder version 1.2.0 and have the following problem
to populate the report i use this query to a MySQL database:
SELECT "user" AS "user", "werk" AS "werk", "DTSTART" AS "DTSTART","DTEND" AS "DTEND", TIMEDIFF(TIME(DTEND),TIME(DTSTART)) AS "TIMEDIF" FROM "werktimer" WHERE "DTEND" > '2001-01-01 00:00:00' ORDER BY "werk", "DTSTART"
this query works when i open it but when i want to launch the report i get the error: Every derived table must have its own alias
can anyone help me with this?
is there an alternative to the Sun Report Builder?
thanks
Marco