Hi, if you model this as a graph you'd have address and country connected with a link. That approach is like a join, so it's not so efficient. However try with:
SELECT FROM address WHERE country NOT IN ( SELECT iso FROM country ) Or: SELECT FROM address LET $isos = ( SELECT iso FROM country ) WHERE country NOT IN $isos Lvc@ On 25 February 2014 17:31, Fabrizio Fortino <[email protected]>wrote: > Hi guys, > > I am trying to execute the following query: > > SELECT FROM address WHERE country IS NOT IN(SELECT iso FROM country) > > but it gets all the records without filtering the ones with the country > code returned from the inner query. > > Any idea? > > Thanks, > Fabrizio > > -- > > --- > 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. > -- --- 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.
