SELECT DISTINCT a.ID1, a.NAME1 FROM TABLE1 a, TABLE2 b WHERE a.ID1 = b.ID2のSQL文は，副問い合わせの条件としてEXISTSを指定して SELECT a.ID1, a.NAME1 FROM TABLE1 a WHERE EXISTS ( SELECT 'X' FROM TABLE2 b WHERE a.ID1 = b.ID2)

<script type="text/javascript"> function aaa(){ for(var i = 1; i <= 6 ; i++ ){ document.getElementById("text" + i).value = i; } } </script><form name="f"> <input type="text" name="text1" id="text1"> <input type="text" name="text2" id="text2"> <input type="text" name="text3" id="text3"> </form>