Jump to content


Photo

Select Statement - what's wrong?


  • Please log in to reply
1 reply to this topic

#1 space1

space1
  • Members
  • Pip
  • Newbie
  • 1 posts

Posted 26 May 2003 - 05:23 AM

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

#2 pallevillesen

pallevillesen
  • Members
  • PipPipPip
  • Advanced Member
  • 135 posts
  • LocationDenmark

Posted 26 May 2003 - 07:04 AM


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.
Palle Villesen, www.birc.dk [br]Bioinformatics Research Center




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users