A.INNER JOIN B.LEFT OUTER JOIN C.RIGHT OUTER JOIN D.FULL OUTER JOIN
A.GROUP BY B.ORDER BY C.WHERE D.INNER JOIN
A.被組合的每個(gè)查詢都可以使用ORDER BY子句 B.兩個(gè)SELECT語(yǔ)句必須輸出同樣的列數(shù) C.兩個(gè)表各相應(yīng)列的數(shù)據(jù)類型必須相同 D.將來(lái)自不同查詢的數(shù)據(jù)組合起來(lái)