1週間でSQLの基礎をマスター

補習-5.UNION

部署テーブルの部署名と社員テーブルの氏名を出力する(縦に出力)SQLを考えてみてください。

>答え

inserted by FC2 system SELECT DEPARTMENT_NM FROM DEPARTMENT UNION SELECT NAME FROM STAFF SELECT DEPARTMENT_CD FROM DEPARTMENT UNION SELECT STAFF_CD FROM STAFF SELECT DEPARTMENT_CD FROM DEPARTMENT UNION SELECT DEPARTMENT_CD FROM STAFF