Thanks. It works! On Tuesday, February 25, 2014 5:08:52 PM UTC, Lvc@ wrote: > > 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]<javascript:> > > 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] <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.
