sql query for retrieving data using join condition.

Question

0.00/5 (No votes)

See more:

sql query for retrieving data using join condition.
shown bellow are the two tables.

Table1                                      Table2                             
      Eid Packet                               Eid Packet    
108020002000012013                 108020002000012013 
108020002000022013                 108020002000022013
108020002000032013                 108020002000052013
108020002000042013                 108020002000062013
108020002000052013                 108020002000072013
108020002000062013                 108020002000102013
108020002000072013                 108020002000112013
108020002000082013                
108020002000092013

i want o/p like bellow.data retrieving based on underline value.

two tables                  1st table un
matched records           Matched records           2nd table un Matched
                                                                                                       
108020002000012013      108020002000032013         108020002000102013
108020002000022013      108020002000042013         108020002000112013
108020002000052013      108020002000082013   
108020002000062013
108020002000072013

Posted 4-Jun-13 20:00pm

subbu a

Updated 4-Jun-13 20:30pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

Comments

chaau 5-Jun-13 2:17am

What have you tried? Hint: for fully matched you would use INNER JOIN, for unmatched you would use LEFT/RIGHT JOINs.
To compare using part of the strings you would use SUBSTRING.
Show us some code that you have written yourself, and we will help you

subbu a 5-Jun-13 2:30am

SELECTtable1.EidPacket
FROM table1, table2
WHERE Ttable1.EidPacket =Ttable1.EidPacket

i am not getting exactly ans. how can i retrieving based on middle value in the record.

Maciej Los 6-Jun-13 1:54am

Is your problem solved?

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)

Maciej Los · Answer 1 · 2013-06-04T20:40:00

Exact match:

SQL

SELECT t1.EidPocket
FROM table1 AS t1 INNER JOIN table2 AS t2 ON t1.EidPacket = t2.EidPocket

Non-matches:

SQL

SELECT EidPocket
FROM table1 AS t1 
WHERE EidPocket NOT IN (SELECT t2.EidPocket
            FROM table1 AS t1 INNER JOIN table2 AS t2 ON t1.EidPacket = t2.EidPocket)

Morea about:
Join's[^]
Visual Representation of SQL Joins[^]