Jump to content

Archived

This topic is now archived and is closed to further replies.

space1

Select Statement - what's wrong?

Recommended Posts

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

Share this post


Link to post
Share on other sites


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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.