如何在sql server 2008中加入查询 [英] How to Join a Query in sql server 2008

问题描述

亲爱的，



这是我对时间和出勤的小问题

  SELECT  A.BADGENUMBER，A.EMPNAME，A.DESIG，（ SELECT   TOP   1 （B.PTIME） FROM  TBL_PUNCH B  WHERE  B.BADGENUMBER = A.BADGENUMBER  AND  B.SN = A.SN） FROM  TBL_EMP A  WHERE  A.SN = '  4550962200016' 
 

任何人都可以使用连接转换它



提前致谢



Kreddy

解决方案

试试这个：

  SELECT   TOP （  1 ）A.BADGENUMBER，A.EMPNAME，A.DESIG，B.PTIME 
  FROM  TBL_EMP A  INNER   JOIN  TBL_PUNCH B  ON  B.BADGENUMBER = A.BADGENUMBER  AND  B.SN = A.SN）
  WHERE  A.SN = '  4550962200016' 

或者这个：

  SELECT   DISTINCT  A.BADGENUMBER，A.EMPNAME，A .DESIG，B.PTIME 
  FROM  TBL_EMP A  INNER   JOIN  TBL_PUNCH B  ON  B.BADGENUMBER = A.BADGENUMBER  AND  B.SN = A.SN）
  WHERE  A.SN = '  4550 962200016' 

关于加入的更多信息：

http://www.w3schools.com/sql/sql_join.asp [ ^ ]

SQL连接的可视化表示 [ ^ ]

我相信下面的查询应该有所帮助。

  SELECT  A.BADGENUMBER， A.EMPNAME，A.DESIG，B.PTIME 
  FROM  TBL_EMP A 
  LEFT   JOIN  TBL_PUNCH B  ON  B.BADGENUMBER = A.BADGENUMBER  AND  B.SN = A.SN 
  WHERE  A.SN = '  4550962200016' 

试试看，也许看看这个有关CodeProject的有用文章 SQL的可视化表示加入 [ ^ ]



谢谢，

  SELECT  
 A.BADGENUMBER，
 A.EMPNAME，
 A.DESIG，
 B.PTIME 
  FROM  TBL_EMP A  JOIN  TBL_PUNCH B 
  ON  B.BADGENUMBER = A.BADGENUMBER  AND  B.SN = A.SN 
  W HERE  A.SN = '  4550962200016' 

Dear All,

Here is my small query for time and attendance

SELECT A.BADGENUMBER,A.EMPNAME,A.DESIG,(SELECT TOP 1(B.PTIME) FROM TBL_PUNCH B WHERE B.BADGENUMBER=A.BADGENUMBER AND B.SN=A.SN) FROM TBL_EMP A WHERE A.SN='4550962200016'

can any one please transform this using joins

Thanks in advance

Kreddy

解决方案

Try this:

SELECT TOP (1) A.BADGENUMBER,A.EMPNAME,A.DESIG,B.PTIME
FROM TBL_EMP A INNER JOIN TBL_PUNCH B ON B.BADGENUMBER=A.BADGENUMBER AND B.SN=A.SN)
WHERE A.SN='4550962200016'

or this:

SELECT DISTINCT A.BADGENUMBER,A.EMPNAME,A.DESIG,B.PTIME
FROM TBL_EMP A INNER JOIN TBL_PUNCH B ON B.BADGENUMBER=A.BADGENUMBER AND B.SN=A.SN)
WHERE A.SN='4550962200016'

More about join''s:
http://www.w3schools.com/sql/sql_join.asp[^]
Visual Representation of SQL Joins[^]

Hi,

I believe the query below should help.

SELECT A.BADGENUMBER, A.EMPNAME, A.DESIG, B.PTIME
FROM TBL_EMP A 
LEFT JOIN TBL_PUNCH B ON B.BADGENUMBER = A.BADGENUMBER AND B.SN = A.SN
WHERE A.SN='4550962200016'

Try that, and maybe check out this really helpful article on CodeProject Visual Representation of SQL Joins[^]

Thanks,

SELECT
        A.BADGENUMBER,
        A.EMPNAME,
        A.DESIG,
        B.PTIME
FROM TBL_EMP A JOIN TBL_PUNCH B
ON B.BADGENUMBER=A.BADGENUMBER AND  B.SN=A.SN
WHERE A.SN='4550962200016'

这篇关于如何在sql server 2008中加入查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！