I have an SQL QUERY that works fine in MS SQL it goes like this.

SELECT tbMembers.MemberId, tbMembers.MemberPass, tbMembers.email,
MAX(tbMemberAccessLvl.AccessLvl) AS AccessLvl
FROM tbMembers INNER JOIN tbMemberAccessLvl ON tbMembers.MemberId =
tbMemberAccessLvl.MemberID
WHERE (tbMembers.MemberId = '445037') AND (tbMembers.MemberPass =
'billabong') OR (tbMembers.MemberPass = 'billabong') AND (tbMembers.email =
'christzar@bigpond.com')
GROUP BY tbMembers.MemberId, tbMembers.MemberPass, tbMembers.email

I have tested it and it returns the right records

BUT when i move it to DWMX2004 to replace the SQL in the Login User Server
behaviour generated SQL it won't work. the DW SQL looks like this:

------
MM_rsUser.Source = "SELECT dbo.tbMembers.MemberId, dbo.tbMembers.MemberPass,
dbo.tbMembers.email, MAX(dbo.tbMemberAccessLvl.AccessLvl) AS AccessLvl"

If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source &
"," & MM_fldUserAuthorization

MM_rsUser.Source = MM_rsUser.Source & " FROM dbo.tbMembers INNER JOIN
dbo.tbMemberAccessLvl ON dbo.tbMembers.MemberId =
dbo.tbMemberAccessLvl.MemberID WHERE (dbo.tbMembers.MemberId='" &
Replace(MM_valUsername,"'","''") &"') AND (dbo.tbMembers.MemberPass='" &
Replace(Request.Form("password"),"'","''") & "') OR
(dbo.tbMembers.MemberPass='" & Replace(Request.Form("password"),"'","''") &
"') AND (dbo.tbMembers.email='" & Replace(MM_valUsername,"'","''") &"')
GROUP BY dbo.tbMembers.MemberId, dbo.tbMembers.MemberPass,
dbo.tbMembers.email"
------

The problem might be that the DWSQL is split into 2 strings and the first
string that contains the MAX can't see the GROUP BY in the second
string......I don't know. Can someone please take a look.