You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
How can I write this not exists syntax for Kibana?
My code in SQL:
WHERE
(mma.mma_data_mov > '2015-12-31 23:59:59') and
MMA_DATA_MOV < '2017-08-20' and not exists ( select 1 from mma b where
b.mma_mat_cod = mma.mma_mat_cod
and b.mma_sba_cod = mma.mma_sba_cod
and b.mma_data_mov < '2017-08-20'
and b.mma_data_mov > mma.mma_data_mov )
order by MMA_DATA_MOV desc;
The text was updated successfully, but these errors were encountered:
How can I write this not exists syntax for Kibana?
My code in SQL:
WHERE
(mma.mma_data_mov > '2015-12-31 23:59:59') and
MMA_DATA_MOV < '2017-08-20' and not exists ( select 1 from mma b where
b.mma_mat_cod = mma.mma_mat_cod
and b.mma_sba_cod = mma.mma_sba_cod
and b.mma_data_mov < '2017-08-20'
and b.mma_data_mov > mma.mma_data_mov )
order by MMA_DATA_MOV desc;
The text was updated successfully, but these errors were encountered: