SQL Server Exists Query

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

I have 2 tables
1.Registration Master
2.Attendance Master

Registration_Master data is as
Official_Email,EmpName,desg
wasif@apv.com ,Mohd Wasif ,Engineer
peter@apv.com ,Peter,Engineer
James@apv.com,james ,Engineer

and
Attendance_Master
consist of
Official_Email,LoginTime
wasif@apv.com ,2011-01-13 17:25:27.267
wasif@apv.com ,2011-01-01 17:25:27.267
peter@apv.com,2011-01-01 17:25:27.267

in this
select * from Attendance_Master where LoginTime=getdate()
it is giving me

wasif@apv.com ,2011-01-13 17:25:27.267

now my requirement is that I want to retrieve all details
from Registration_Master who don't have record in Attendance_Master
in today's date. that is

VB

peter@apv.com ,Peter,Engineer
James@apv.com,james ,Engineer

Please let me know how to do it?
Thanking You
Mohammad Wasif

Posted 13-Jan-11 0:57am

Mohd Wasif

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Estys · Answer 1 · 2011-01-13T01:07:00

Solution 1

Something like this :

select * from Registration_Master where Official_Email NOT IN (select Official_Email from Attendance_Master where Official_Email = Registration_Master.Official_Email);

Cheers

Posted 13-Jan-11 1:07am

Estys

Comments

fjdiewornncalwe 13-Jan-11 10:29am

We really shouldn't give the OP the answer without them showing us what they attempted first. They won't really learn anything if we just hand it to them.
That being said, your answer is valid so you still get the +5.

Estys 13-Jan-11 10:36am

@marcus kramer : I know, but I don't always want to impose edifying words on the OP :)
Besides that, it's not complete.