瀹為獙鍏?/p>
瀹為獙鍚嶇О锛氳繛鎺ユ煡璇?/p>
涓�銆佸疄楠岀洰鐨?/p>
鎺屾彙浣跨敤杩炴帴鐨勬柟娉曚粠澶氫釜琛ㄤ腑鏌ヨ鏁版嵁銆?/p>
鐞嗚В鍐呰繛鎺ャ�?/p>
澶栬繛鎺?/p>
锛堝寘鎷乏澶栬繛鎺ャ�?/p>
鍙冲杩炴帴鍜屽叏澶栬繛鎺ワ級
銆佽嚜韬繛鎺ョ殑姒傚康鍜屼娇鐢ㄣ�傝姹傚鐢熺啛缁冩帉鎻″湪
FROM
瀛?/p>
鍙ュ拰鍦?/p>
WHERE
瀛愬彞涓寚瀹氳繛鎺ユ潯浠剁殑杩欎袱绉嶆柟娉曘�?/p>
浜屻�佸疄楠屽師鐞?/p>
鍦ㄦ煡璇㈣鍙ョ殑
FROM
瀛愬彞涓敤浠ヤ笅褰㈠紡瀹炵幇鍚勭杩炴帴鎿嶄綔锛?/p>
飦?/p>
FROM
琛?/p>
1
[INNER]
JOIN
琛?/p>
2
ON
琛?/p>
1
锛?/p>
鍒楀悕
=
琛?/p>
2
锛?/p>
鍒楀悕
锛堝疄
鐜板唴杩炴帴锛?/p>
飦?/p>
FROM
琛?/p>
1
LEFT
[OUTER]
JOIN
琛?/p>
2
ON
琛?/p>
1
锛?/p>
鍒楀悕
=
琛?/p>
2
锛?/p>
鍒?
鍚?/p>
锛堝疄鐜板乏澶栬繛鎺ワ級
飦?/p>
FROM
琛?/p>
1
RIGHT
[OUTER]
JOIN
琛?/p>
2
ON
琛?/p>
1
锛?/p>
鍒楀悕
=
琛?/p>
2
锛?/p>
鍒?
鍚?/p>
锛堝疄鐜板彸澶栬繛鎺ワ級
飦?/p>
FROM
琛?/p>
1
FULL
[OUTER]
JOIN
琛?/p>
2
ON
琛?/p>
1
锛庡垪鍚?/p>
=
琛?/p>
2
锛庡垪
鍚?/p>
锛堝疄鐜板叏澶栬繛鎺ワ級
飦?/p>
FROM
琛?/p>
1
AS
鍒悕
1
JOIN
琛?/p>
1
AS
鍒悕
2
ON
鍒悕
1
锛庡垪鍚?/p>
=
鍒悕
2
锛庡垪鍚?/p>
锛堝疄鐜拌嚜韬繛鎺ワ級
鍦ㄦ煡璇㈣鍙ョ殑
WHERE
瀛愬彞涓敤浠ヤ笅褰㈠紡瀹炵幇鍚勭杩炴帴鎿嶄綔锛?/p>
飦?/p>
FROM
琛?/p>
1
锛岃〃
2
WHERE
琛?/p>
1
锛庡垪鍚?/p>
=
琛?/p>
2
锛庡垪鍚?/p>
锛堝疄鐜板唴杩炴帴锛?/p>
飦?/p>
FROM
琛?/p>
1
锛岃〃
2
WHERE
琛?/p>
1
锛庡垪鍚?/p>
*=
琛?/p>
2
锛庡垪鍚?/p>
锛堝疄鐜板乏澶栬繛鎺ワ級
飦?/p>
FROM
琛?/p>
1
锛岃〃
2
WHERE
琛?/p>
1
锛庡垪鍚?/p>
=*
琛?/p>
2
锛庡垪鍚?/p>
锛堝疄鐜板彸澶栬繛鎺ワ級
飦?/p>
FROM
琛?/p>
1
AS
鍒悕
1
锛岃〃
1
AS
鍒悕
2
WHERE
鍒悕
1
锛庡垪鍚?/p>
=
鍒悕
2
锛庡垪鍚?/p>
锛堝疄鐜拌嚜韬繛鎺ワ級
涓夈�佸疄楠岃澶?/p>
瀹夎鏈?/p>
SQL SERVER 2005
鐨勮绠楁満銆?/p>
鍥涖�佸疄楠岀ず渚?/p>
1
銆佹绱?/p>
product
琛ㄥ拰
sale_item
琛ㄤ腑鏁伴噺澶т簬
2
鐨勭浉鍚屼骇鍝佺殑浜у搧缂栧彿銆佷骇鍝佸悕
绉般�佹暟閲忋�佸崟浠枫�?/p>