Hi,

I have three tables named User, UserGroup, UserRelations.
User table contains informatrion about the user like userId, userName,
email,..
UserGroup table contains information about all the groups like groupId,
groupName,..
UserRelations table contains information about groupId, ele_id(UserId
from User table, only if the user is in a particular group).
User table also contains information of other users who are not part of
the UserGroup. And one user can be part of any number of groups.

Now my requirement is to fetch all the columns from user table + His
group name from UserGroup (if he belongs to a particular group,
otherwise empty).

Can any one specify the query to get the required details.


Regards,
Rambabu






[Non-text portions of this message have been removed]