Hi all, another question about AQL and CONTAINS. Most of the AQL samples use just one branch in the FROM clause, like:
EHR CONTAINS COMPOSITION CONTAINS OBSERVATION. I'm wondering what would be the correct FROM notation when more than one ENTRY is needed. Some examples below. SELECT o1/data[...]/.../value, o2/..., .... FROM COMPOSITION c [archid] CONTAINS OBSERVATION o1 [archid2], COMPOSITION c [archid] CONTAINS OBSERVATION o2 [archid3], COMPOSITION c [archid] CONTAINS OBSERVATION o3 [archid4] WHERE ... SELECT o1/data[...]/.../value, o2/..., .... FROM COMPOSITION c [archid] CONTAINS OBSERVATION o1 [archid2] AND CONTAINS OBSERVATION o2 [archid3] AND CONTAINS OBSERVATION o3 [archid4] WHERE ... Thanks! -- Ing. Pablo Pazos GutiƩrrez e: pablo.pa...@cabolabs.com p: +598 99 043 145 skype: cabolabs <http://cabolabs.com/> http://www.cabolabs.com https://cloudehrserver.com Subscribe to our newsletter <http://eepurl.com/b_w_tj>
_______________________________________________ openEHR-technical mailing list openEHR-technical@lists.openehr.org http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org