How to write query with joins as oracle example below:

select c.ORG_ID, count(u.chave) from compromisso c
join USUARIO u
  on c.RESPONSAVEL_ID = u.id
join ESTABELECIMENTO est
  on est.id = c.ESTABELECIMENTO_ID
join EMPRESA em
  on est.EMPRESA_ID = em.id
group by c.ORG_ID

-- 

--- 
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.

Reply via email to