Hi For me, the union is returning duplication. I expected union not to return duplicates. Is there anything that Im missing? \
Cheers Vishnu On Friday, August 2, 2013 9:58:37 PM UTC+5:30, Lvc@ wrote: > > Hi, > this is not supported, so you've to execute them as separate query and > then join the result using the UNION: > > select expand( $c ) let $a = ( select from E ), $b = ( select from V ), $c > = union( $a, $b ) > > Lvc@ > > PS: I found a small bug on union now fixed in 1.6.0-SNAPSHOT. > > > On 2 August 2013 10:40, dabro <[email protected] <javascript:>> wrote: > >> Hi >> When I execute query: >> >> select from OUser, V, E >> >> I get this error as result: >> >> Error: >> com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on >> parsing command at position #17: Invalid keyword 'V' >> Command: select from OUser, V, E >> -------------------------^ >> >> Is it possible to get result from multiple tables? >> I use OrientDB 1.5 >> >> -- >> >> --- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- --- 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.
