用于使用连接条件检索数据的SQL查询。 [英] sql query for retrieving data using join condition.

问题描述

用于使用连接条件检索数据的SQL查询。

下面显示的是两个表格。

表1表2 
 Eid数据包Eid数据包
 1080  2000200001  2013 1080  2000200001  2013 
 1080  2000200002  2013 1080  2000200002  2013 
 1080  2000200003  2013 1080  2000200005  2013 
 1080  2000200004  2013 1080  2000200006  2013 
 1080  2000200005  2013 1080  2000200007  2013 
 1080  2000200006  2013 1080  2000200010  2013 
 1080  2000200007  2013 1080  2000200011  2013 
 1080  2000200008  2013 
 1080  2000200009  2013 

i希望o / p像bellow.data检索基于下划线值。

两张桌子1st table un 
匹配记录匹配的记录第二张桌子没有比赛
 
 1080  2000200001  2013 1080  2000200003  2013 1080 < u> 2000200010  2013 
 1080  2000200002  2013 1080  2000200004  2013 1080  2000200011  2013 
 1080  2000200005  2013 1080  2000200008  2013 
 1080  2000200006  2013 
 1080  2000200007  2013 

解决方案

完全匹配：

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

不匹配：

  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关于：

加入 [ ^ ]

Visual Re SQL联接的表示 [ ^ ]

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

解决方案

Exact match:

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

Non-matches:

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[^]

这篇关于用于使用连接条件检索数据的SQL查询。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！