sql help

[Paul M]

Hi
I need to remove
tblMembershipOptions
tblMembershipOptions.MembershipOptionID = "
from the sql below

These fields are all in tblMembers SELECT ID,UserName,MembershipOption
I have tried but I must be doing something wrong
Paul M


sSQL="SELECT ID,UserName,MembershipOption FROM " & _
" tblMembershipOptions INNER JOIN tblMembers ON
tblMembershipOptions.MembershipOptionID = " & _
" tblMembers.MembershipOption WHERE UserName ='" & sUsername & "'" & _
" AND MemberPassword = '" & sPassword & "'"

 

[p c]

Are all fields in the same table? this will do it

sSQL="SELECT ID,UserName,MembershipOption " &_
" FROM tblMembers"
" WHERE UserName ='" & sUsername & "'" & _
" AND MemberPassword = '" & sPassword & "'"

...PC

 

[Paul M]

Thanks "pc"
Paul M

Are all fields in the same table? this will do it

sSQL="SELECT ID,UserName,MembershipOption " &_
" FROM tblMembers"
" WHERE UserName ='" & sUsername & "'" & _
" AND MemberPassword = '" & sPassword & "'"

..PC