Hi, for your example you can try this query select count(*) from oemdetail where Build = $b[0].name let $b = (select sanityBuild from currenttable where version = '11.6.0')
or this function var g=orient.getGraph(); var b=g.command('sql','select sanityBuild from currenttable where version = '11.6.0'') var c=b[0].getProperty('sanityBuild'); var d=g.command('sql',"select count(*) from oemdetail where Build = '"+c+ "'"); return d[0].getProperty('count'); Regards, Alessandro -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.