Re: Please help me with this join

[Immo Heikkinen]

I don't think it is possible to use distinct with aggregate.

to 28. heinäkuuta 2016 klo 12.04 developeronly <develo...@gmail.com> kirjoitti:

Now i am able to count it but not distinct
Latest query is

(select person

  (fields :*)

  (aggregate (count :orders.id) :count_images :person.id)

  (aggregate (count :items.id) :count_analyses :person.id)

  (join orders (= :person.id :orders.person_id))

  (join items (= :person.id :items.person_id))

  (where {:user_id user-id}))

--
You received this message because you are subscribed to the Google Groups "Korma" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sqlkorma+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.