从a,b中选择a.LastName,b.OrderNO,其中a.P_id!= b.P_id(此查询的结果等于Join Query结果的类型) [英] Select a.LastName,b.OrderNO from a,b where a.P_id !=b.P_id (Result of This Query equals to which type Join Query result)
问题描述
我有两个表a和b
表a
P_Id姓氏名字地址城市
1 Hansen Ola Timoteivn 10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Pettersen Kari Storgt 20斯塔万格
表b
O_Id OrderNo P_Id
1 77895 3
2 44678 3
3 22456 1
4 24562 1
5 34764 15
从a,b中选择a.LastName,b.OrderNO,其中a.P_id!= b.P_id
任何人请建议我这个查询的输出是哪种类型的连接查询结果像内部,外部,自我等
请参考这些链接:
加入基础知识 [< a href =http://msdn.microsoft.com/en-us/library/ms191517%28v= sql.105%29.aspxtarget =_ blanktitle =新窗口> ^ ]
sql join [ ^ ]
很棒的文章: SQL联接的可视化表示 [ ^ ]
Hi,
I have two table a and b
Table a
P_Id LastName FirstName Address City
1 Hansen Ola Timoteivn 10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Pettersen Kari Storgt 20 Stavanger
Table b
O_Id OrderNo P_Id
1 77895 3
2 44678 3
3 22456 1
4 24562 1
5 34764 15
Select a.LastName,b.OrderNO from a,b where a.P_id !=b.P_id
Any one please suggest me the output of this query is which type of join Query result as like inner,Outer,Self etc
Please refer these links:
Join Fundamentals[^]
sql joins[^]
And great article: Visual Representation of SQL Joins[^]
这篇关于从a,b中选择a.LastName,b.OrderNO,其中a.P_id!= b.P_id(此查询的结果等于Join Query结果的类型)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!