how to identify the people who are having 1st one but not having 2nd table

Question

1.00/5 (2 votes)

See more:

i have 2 table qstn is how to identify the people who are having 1st one not having in 2nd table use only joins (not use set or subquery's...)

customer calls
id nm id calid
1 xx 1 009
2 vv 5 999

Posted 20-Sep-13 0:41am

mahesh202

Add a Solution

Comments

Raja Sekhar S 20-Sep-13 6:51am

Is this Your Question...
Select People present in first table and not in second table..?
Customer and Calls are different tables... or it is a single table..?

mahesh202 20-Sep-13 6:59am

2 diff tables

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)

Raja Sekhar S · Answer 1 · 2013-09-20T01:07:00

SQL

Create Table #Temp1 
	(
	 Id Int,
	 nm varchar(40)
	)

Create Table #Temp2
	(
	 Id Int,
	 CallId Int
	)

Insert into #Temp1
Values(1,'xx'),(2,'vv'),(3,'zz')

Insert into #Temp2
Values(1,09),(5,999)

Select t1.Id,t1.nm From #Temp1 t1	-- Present in #Temp1 not in #Temp2
Left Outer Join #Temp2 t2 on t1.Id=t2.Id
Where t2.Id is null

Select t2.Id,t2.CallId From #Temp1 t1	-- Present in #Temp2 not in #Temp1
Right Outer Join #Temp2 t2 on t1.Id=t2.Id
Where t1.Id is null

Select t1.Id,t1.nm,t2.CallId From #Temp1 t1	-- Present in Both Tables
Inner Join #Temp2 t2 on t1.Id=t2.Id

Select COALESCE(t1.Id,t2.Id)[Id],t1.nm,t2.CallId From #Temp1 t1	  -- Selecting All Records
Full Outer Join #Temp2 t2 on t1.Id=t2.Id

Drop Table #Temp1 
Drop Table #Temp2