i just want to get unique data which is not available in second table column

Question

0.00/5 (No votes)

See more:

i have two table each one has single column named as "Accessno " and "AccessNo " i just want to get unique data which is not available in second table column
here is my sql query
"select m.Accessno from tatbx m left join tb_mstrmaterial d on d.AccessNo=m.Accessno where d.is null"
first table name :tatbx
seccnd table name : tb_mstrmaterial

thnx in aduvance

tatbx | tb_mstrmaterial
Accessno | AccessNo
a1 | a1
a2 | a4
a3 |
a4 |
the out put should come like a2,a3

Posted 15-Jun-15 19:33pm

Muhammed Ali Kc

Updated 15-Jun-15 20:03pm

v5

Add a Solution

Comments

OriginalGriff 16-Jun-15 1:54am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Perhaps sample data from both tables, and an example of teh output you want would help?
Use the "Improve question" widget to edit your question and provide better information.

2 solutions

Solution 1

I think it's a small error in your SQL. Try changing this:

SQL

select m.Accessno from tatbx m left join tb_mstrmaterial d on d.AccessNo=m.Accessno where d.is null

To

SQL

select m.Accessno from tatbx m left join tb_mstrmaterial d on d.AccessNo=m.Accessno where d.AccessNo is null

Posted 15-Jun-15 20:27pm

OriginalGriff

Comments

Muhammed Ali Kc 16-Jun-15 2:41am

i want only unique values from first table like
a1|a1
a2|a3
a3|
the result should come like this a2 only
thnx

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)

Member 519379 · Accepted Answer · 2015-06-16T10:55:00

Solution 2

This should also work:

SELECT Accessno FROM tatbx EXCEPT SELECT AccessNo FROM tb_mstrmaterial

Posted 16-Jun-15 10:55am

Member 519379

Comments

Muhammed Ali Kc 24-Jun-15 6:53am

thnx..