Select Statement - what's wrong?

[space1]

Any idea why this statement doesn\'t work? I can\'t figure out what\'s wrong.

Thanks!!

 

SELECT tResponses.EventID, tResponses.MemberID, tUsers.Username

FROM tResponses, tUsers

WHERE tResponses.Rsvp=\'Y\'

AND tResponses.EventID = \'17\'

AND tResponses.MemberID = tUsers.MemberID

[pallevillesen]

SELECT R.EventID, R.MemberID, U.Username

FROM tResponses R, tUsers U 

WHERE  R.MemberID = U.MemberID

AND R.Rsvp=\'Y\'

AND R.EventID = \'17\'
;

 

If your coloumn names are correct, it should work... It\'s just a straight join.

 

P.