Hi Markus,
You are right, the query on my previous example does not make sense. But I
had just tried to explain the situation that I'm having trouble with.
I hope the query below has more meaning then the previous one.
Just trying to group actions by user_id, then join with users and applying
rownum.
SELECT *
FROM (SELECT USER_NAME
FROM (SELECT ACTION_USER_ID
FROM TBL_ACTION
GROUP BY ACTION_USER_ID
HAVING COUNT (*) > 2),
TBL_USER
WHERE ACTION_USER_ID = USER_ID)
WHERE ROWNUM < 100
Thanks,
Erdem
--
You received this message because you are subscribed to the Google Groups
"Castle Project Users" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/castle-project-users/-/X215aTJfa1lXOU1K.
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/castle-project-users?hl=en.
