Jump to content

Archived

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

markmuir

Searching

Recommended Posts

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

Share this post


Link to post
Share on other sites
try this

[code]SELECT * FROM registration LEFT JOIN activity ON registration.MemNo = activity.MemNo WHERE activity.MemNo IS NULL[/code]

Ray

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.