Hi Dave,
I meant that the first subset of data is returned in around 18 millisconds if I don't say distinct, which obviously leaves out some records which do not in the subset.

what I have:

User*----*Role
User-----*loginsession
User----*UserType
User-------*Profile
defaultProfile-----*Address
Address----phone

here userroleassign and userusertypeassign are the jooin tables for many to many associations between user==>role and user==>usertype respectively.

Now I want some fields from user,some fields from usertype,some fields from
loginSession,and phone number from his defaultprofile-->adresss where user has a certain role.

I could not come up with a query that gives me the above explained data set.

Can you help build a query that gets the above resultset?

Thanks and Regards,
Samba