次の四つ書き方があります。(結果同じ) SELECT t1.no , t1.type , t2.name FROM table1 t1 INNER JOIN table2 t2 ON t1.type = t2.type AND t2.locale = 'ja' / SELECT t1.no , t1.type , t2.name FROM table1 t1 INNER JOIN table2 t2 ON t1.type = t2.type where t2.locale = 'ja' / SELECT t1.no , t1.type , t2.name FROM table1 t1 , table2 t2 where t1.type = t2.type and t2.locale = 'ja' / SELECT t1.no , t1.type , t2.name FROM table1
![内部結合する時の結合条件と制約条件について](https://cdn-ak-scissors.b.st-hatena.com/image/square/ea4901b03391bb13a3b960b156f47c2763edd364/height=288;version=1;width=512/https%3A%2F%2Foshiete.xgoo.jp%2Fimages%2Fsp%2Fqa_recommend%2F2102_2.jpg)