I have stored procedure which needs to be translated in OrientDB sql query.
So sql goes like this:
select a.FormNumber, b.OrderNumber, c.TagNumber from SomeTable a
inner join SomeTable2 b on (... some join expression)
inner join SomeTable3 c on (... some join expression)
where (...some where expression)
except
select d.Number1, e.Number2 e.Number3 from SomeTable4 d
inner join SomeTable5 e on (... some join expression)
where (...some where expression)
That's where I need 'except' operator.
And the whole expression is not easy to translate
On Tuesday, 28 October 2014 16:42:35 UTC+1, Lvc@ wrote:
>
> Hi Bojan,
> What do you need? Difference in collections?
>
> Lvc@
>
>
> On 28 October 2014 15:32, BojanV <[email protected] <javascript:>> wrote:
>
>> Does OrientDB support "except" operator at all? (or any another variant
>> of it?)
>>
>>
>> On Tuesday, 28 October 2014 13:14:07 UTC+1, BojanV wrote:
>>>
>>> @ amoore
>>>
>>> I see you originally started thread on stackoverflow where you asked if
>>> there was "except" operator in OriendDB. Did you have any more success? Did
>>> "difference" helped you? Or how did you simulate "except" SQL operator?
>>>
>>
>>
>>
>> --
>>
>> ---
>> 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/d/optout.
>>
>
>
--
---
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.
