Posted by SirCodesALot on 01/30/08 23:07

I need some help, i need to join 4 tables but get a huge number of
results, so I must be doing something wrong.

here are my tables

WebGroups
- WebId
-Title (values: "Admin" or "NonAdmin")

WebGroupMembers
- WebId
- MemberId

Webs
- WebId
- Title

UserInfo
-MemberId
-Title

I want to return the Distinct UserInfo.Title, Webs.Title,
WebGroups.Title where WebGroups.Title="Admin"

So here is what I thought should work

Select Disctinct UserInfo.Title, Webs.Title, WebGroups.Title from
Userinfo
INNER JOIN WebGruopMembers
ON UserInfo.MemberID = WebGroupMember.MemberID
INNER JOIN WebGroups
ON Webgroups.WebId = WebGroupMember.WebID
INNER JOIN Webs
ON WebGroups.WebId = WebGroups.WebID
WHERE WebGroups.Title = "Admin"

Any ideas?

• Next in forum: Re: Avg() not including 0's
• Prev in forum: Re: trig errors
• Thread view: Join 4 tables - can it be done?

[Reply to this message]