表の結合

例

/******************************************************
結合
******************************************************/
SELECT t1.hoge 
FROM table1 t1 ,table2 t2
WHERE t1.id = t2.id;


/******************************************************
外部結合
******************************************************/
SELECT t1.id
FROM table1 t1 ,table2 t2
WHERE t1.id = t2.id (+);

SELECT t1.id
FROM table1 t1 ,table2 t2
WHERE t1.id (+) = t2.id;


/******************************************************
2つ以上の表
******************************************************/
SELECT t1.id , t3.deptname
FROM table1 t1 ,table2 t2,table3 t3
WHERE 	t1.id = t2.id
	t1.deptid = t3.deptid(+);


/******************************************************
副問い合わせ
******************************************************/
SELECT t1.hoge 
FROM table1 t1 ,(SELECT id FROM hogehoge WHERE id BETEEEN 10 AND 15) t2
WHERE t1.id = t2.id;