Jump to content


Photo

Searching


  • Please log in to reply
1 reply to this topic

#1 markmuir

markmuir
  • Members
  • Pip
  • Newbie
  • 9 posts

Posted 20 September 2006 - 02:41 PM

Major problem here!!

I have got two tables within my database called "registration" and "activity". Within both tables is a field called MemNo.  What I'm wanting to do is query the registration table for a certain town and a certain day that I type in. I then want display the users Name, Address and MemNo from the Registration table but I want to leave out users that have already completed an activity.

Hope everyone understands my explanation.

Thanks

#2 craygo

craygo
  • Staff Alumni
  • Advanced Member
  • 1,973 posts
  • LocationRhode Island

Posted 20 September 2006 - 03:59 PM

try this

SELECT * FROM registration LEFT JOIN activity ON registration.MemNo = activity.MemNo WHERE activity.MemNo IS NULL

Ray




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users