Hi Michael,
thank you very much for your prompt answer.
What I want to achieve is, counting the number of distinct items,
grouped by user_name
Given
Item1:
item_id = 1
service_id = 'test'
item_class = 'dummy'
Item2:
item_id = 2
service_id = 'other'
item_class = 'dummy'
Invoice1:
id = 1
user_name = 'lorem'
item = Item1
Invoice2:
id = 2
user_name = 'lorem'
item = Item1
Invoice3:
id = 3
user_name = 'ipsum'
item = Item1
Invoice4:
id = 4
user_name = 'ipsum'
item = Item2
the expected result is:
user: lorem, distinct item count : 1
user: ipsum, distinct item count : 2
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
