■

https://it.notepad-blog.com/tool/db/oracle/293/

https://medium-company.com/%E5%86%85%E9%83%A8%E7%B5%90%E5%90%88-%E5%A4%96%E9%83%A8%E7%B5%90%E5%90%88-%E9%81%95%E3%81%84/

■WHEREを使った例

SELECT
社員.社員ID, 社員.社員名, 社員.部署ID, 部署マスタ.部署名
FROM
社員, 部署マスタ
WHERE
社員.部署ID = 部署マスタ.ID;

■INNER JOINを使った例

SELECT
社員.社員ID, 社員.社員名, 社員.部署ID, 部署マスタ.部署名
FROM
社員 INNER JOIN 部署マスタ ON 社員.部署ID = 部署マスタ.ID;

SELECT文で複数テーブルを結合して取得
https://kowaza.withinit.com/oracle/ora_select_join.html

select
T1.ID
, T1.NAME
, T2.CAR_NAME
from
TBL_USER T1
, TBL_CAR T2
where
T1.CODE = T2.CODE
order by
T1.ID asc

https://smart-hint.com/sql/join-basic/
JOIN｜2つのテーブルを結合する

https://johobase.com/select-join-sql/

SELECT studentno,name FROM act_baseball
UNION
SELECT studentno,name FROM act_soccer

https://sql-oracle.com/?p=1384

select distinct

SELECT DISTINCT FROM sample1_employees

https://csharp.sql55.com/cookbook/how-to-get-distinct-rows-from-datatable.php

SELECT DISTINCT NOUZ FROM R_NT
SELECT DISTINCT ZAIZ FROM R_ZT

(select DEPTNO, DNAME from DEPT)
union
(select DEPTNO, JOB from EMP)

(SELECT DISTINCT DEPTNO from DEPT)
union
(SELECT DISTINCT DEPTNO from EMP)