Sorry for the duplication accurate definition: missing FROM-clause entry for table "a" --------------------------------begin TEST 3 (- error) drop table if exists a, b; create table a (id int); create table b (id int, d date, n numeric(12,2)); insert into a values (1); insert into b values (1, now(), 100); select * from a --where id - (select coalesce(sum(id), 0) from b where id=a.id and d > null) <0 union select * from a ORDER BY /*a.*/id
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
