如何从两个表中获取数据 [英] How to fetch data from two Tables
本文介绍了如何从两个表中获取数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
亲爱的先生,我有两个表一个是DepartmentUser,第二个是TransferDetail
DepartmentUser有以下数据
DUID Fname Lname DOB地址
1 Jitendra Gupta 1/1/1998 N-12
2 Veeru gupta 1/3/1995 s-56
和
TransferDetail
TID TransferByFrom TransferByTo Date
1 1(DUID)2(DUID)2015年1月1日
2 2(DUID)1(DUID)5/7/2015
现在我想要结果使用sql的形式
TID TransferByFrom TransferByTo Date
1 Jitendra(Fname)Veeru(Fname)1/1/2015
2 Veeru(Fname)Jitendra(Fname)2015/5/7
请帮忙。
谢谢提前...
解决方案
< blockquote>你好,
你必须在上面给定的表之间进行连接。
SELECT A.TID,B.FNAME,C.FNAME,A .date FROM TransferDetail INNER JOIN DepartmentUser B ON A.TransferByFrom = B.DUID INNER JOIN DepartmentUser C ON A.TransferByTo = C.DUID
谢谢
animesh
使用DepartmentUser在TransferDetail上进行两个左连接,一个用于键TransferByFrom,第二个用于键TransferByTo
如下
选择 TID,TransferByFrom = frm.fname,TransferByTo = To.Fname,日期
来自 TransferDetail TD
左 加入 DepartmentUser frm 开启 TD.TransferByFrom = frm.DUID
左 加入 DepartmentUser 至 开启 TD.TransferByTo = To.DUID
Dear sir i have two table one is DepartmentUser and Second is TransferDetail
DepartmentUser is having following data
DUID Fname Lname DOB Address
1 Jitendra Gupta 1/1/1998 N-12
2 Veeru gupta 1/3/1995 s-56
and
TransferDetail
TID TransferByFrom TransferByTo Date
1 1(DUID) 2(DUID) 1/1/2015
2 2 (DUID) 1(DUID) 5/7/2015
Now i want result IN form of using sql
TID TransferByFrom TransferByTo Date
1 Jitendra(Fname) Veeru(Fname) 1/1/2015
2 Veeru(Fname) Jitendra(Fname) 5/7/2015
please help to do this.
thanks advance...
解决方案
Hello ,
you have to make join between above given tables .
SELECT A.TID,B.FNAME,C.FNAME,A.date FROM TransferDetail A INNER JOIN DepartmentUser B ON A.TransferByFrom =B.DUID INNER JOIN DepartmentUser C ON A.TransferByTo=C.DUID
thanks
animesh
Make two left joins on TransferDetail with DepartmentUser one for the key TransferByFrom and 2nd for the key TransferByTo
As below
select TID, TransferByFrom=frm.fname, TransferByTo=To.Fname,Date from TransferDetail TD Left Join DepartmentUser frm On TD.TransferByFrom=frm.DUID Left Join DepartmentUser To On TD.TransferByTo=To.DUID
这篇关于如何从两个表中获取数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文