Hi All, I'm working with a document db where I have two classes (say A and B) which are not linked but have an attribute which is common (say externalId)
I'm trying to filter out the entries in A, which are also present in B (basically do an inner join). I'm using the IN filter. Following is my query SELECT FROM A WHERE externalId IN (SELECT list(externalId) FROM B) The query does not return results, But there are matching records if you analyze the data. However, if I copy the result coming from the sub query (which is a list of external ids) and use that as the list searched by IN, I get data. Much appreciated if someone could shed some light on this. Cheers Omega -- --- 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/d/optout.
