Re: [orientdb] Using SELECT WHERE IN ()

2015-05-07 Thread Luigi Dell'Aquila
Hi Omega, could you please try with expand() function? SELECT FROM A WHERE externalId IN (SELECT expand(list(externalId)) FROM B) this should fix the problem Luigi 2015-05-07 9:43 GMT+02:00 Omega Silva : > Hi All, > > I'm working with a document db where I have two classes (say A and B) > w

[orientdb] Using SELECT WHERE IN ()

2015-05-07 Thread Omega Silva
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