Quoting Rickard Öberg <[email protected]>:
Isn't it possible to do it in one select by using joins?
The tables are not referencing each other - they only reference that main entity table by having entity_pk column in them. Each table has separate primary key, qname_id, which is independent for each table. And I can't use SQL UNIONs either (in sensible manner at least), since the value column type varies for each QName.
I guess it could be done using left outer joins, but then again, i would end up with as many columns as entity has QNames, and only one column would be non-null for each row - overall, a big mess. I recall doing something similar to that in previous iterations, and I encountered some problem there which ruined that whole concept. :)
_______________________________________________ qi4j-dev mailing list [email protected] http://lists.ops4j.org/mailman/listinfo/qi4j-dev
