markmuir Posted September 20, 2006 Share Posted September 20, 2006 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 Quote Link to comment Share on other sites More sharing options...
craygo Posted September 20, 2006 Share Posted September 20, 2006 try this[code]SELECT * FROM registration LEFT JOIN activity ON registration.MemNo = activity.MemNo WHERE activity.MemNo IS NULL[/code]Ray Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.