Any help would really be appreciated. Thanks, Tia
On Monday, February 17, 2014 5:33:10 PM UTC-8, tia wrote: > > Hi, > > *Running version: orientdb-community-1.7-SNAPSHOT* > > I know that SELECT of direct multiple targets are not supported but was > wondering if you have any hints on how to do the following type of query. > > select expand($c) > let $a = (select in.value as DLABEL from samplelabels where out.value IN > (select in.value from samplerecs where out.value = "IN USE")), > $b = (select in.value as RCODE from samplerx where out.value IN > (select in.value from samplerecs where out.value = "IN USE")), > $c = union($a, $b) > > I currently get: > ----+-----+----------------------------------------+-------- > # |@RID |DLABEL |RCODE > > ----+-----+----------------------------------------+-------- > 0 |#-2:1|ALBUTEROL 0.083% INH SOL PREMIXED--INH 2|null > 1 |#-2:2|IBUPROFEN 100MG_5ML SUSP ($.30_120ML)--P|null > 2 |#-2:3|AURALGAN*EQ* OTIC SOLN |null > 3 |#-2:4|AUGMENTIN ES 600MG_5ML--PO 600MG_5ML SUS|null > 4 |#-2:5|ACETAMINOPHEN--RECT 120MG SUPP |null > 5 |#-2:1|null |H6351279 > 6 |#-2:2|null |H6351281 > 7 |#-2:3|null |H6351276 > 8 |#-2:4|null |H6351275 > 9 |#-2:5|null |H6351278 > 10 |#-2:0|null |null > > ----+-----+----------------------------------------+-------- > > > > But, am trying to find some way to get this footprint somehow: > > ----+-----+----------------------------------------+-------- > # |@RID |DLABEL |RCODE > > ----+-----+----------------------------------------+-------- > 0 |#-2:1|ALBUTEROL 0.083% INH SOL PREMIXED--INH 2|H6351279 > 1 |#-2:2|IBUPROFEN 100MG_5ML SUSP ($.30_120ML)--P|H6351281 > 2 |#-2:3|AURALGAN*EQ* OTIC SOLN |H6351276 > 3 |#-2:4|AUGMENTIN ES 600MG_5ML--PO 600MG_5ML SUS|H6351275 > 4 |#-2:5|ACETAMINOPHEN--RECT 120MG SUPP |H6351278 > ----+-----+----------------------------------------+-------- > > p.s. I also know about the extra NULL record bug returned from union() . > > Thanks for your help, > > Tia > > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
