×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Finding records in a lookup that ARE NOT reference in a main table

Finding records in a lookup that ARE NOT reference in a main table

Finding records in a lookup that ARE NOT reference in a main table

(OP)
I am have a difficult time trying to write this SQL statement.
Would someone give me a hand with it?

I have three tables linked linearly:
Borrowers
CodeCompletions
Codes (Lookup Table)

A Borrower has to complete all of the codes in the Codes table.
As the codes are being completed a record is entered in the CodeCompletions table.

What I need are the codes that the borrower has NOT yet completed.

Borrowers linked to CodeCompletions via "SSN"
CodeCompletions linked to Codes via "ProcessingCodes"

This seems pretty standard. Would someone help me put this information in a form? I tried using a subform but it doesn't work. The value to link the forms on is NULL in the Codes table.

Any help would be appreciated!
Aaron

 

RE: Finding records in a lookup that ARE NOT reference in a main table

I'm not clear on your database design, but I believe the answer will involve using a subquery.

Create a query that returns all the codes that have been answered.  Copy the SQL syntax of the query.

Your final SQL will read something like this:

Select Whatever
From Whereever
Where Code not in (YourCopiedSQLCodeHere);

Does that make sense?

Kathryn
 
 
 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close