string whereDEL_R = "R." + col1 + "," + "R." + col2;
string whereDEL_X = "X." + col1 + "," + "X." + col2;
string strSql_DEL =
"delete from " + repTN +
" where (" + whereDEL_R + ")" +
" not in (select " + whereDEL_X + " from " + xbbTN + ")";
DELETE FROM tab1 a
WHERE
(a.col1,a.col2) NOT IN (SELECT
b.col1
,b.col2
FROM
tab2 b);
strSql = strSql_DEL;
DB(strSql);
Console.WriteLine(strSql+"\r\n");
Console.WriteLine("完了");
Console.WriteLine()
textbox2.text = strSql+"\r\n"
textbox2.text = "\r\n" + textbox2.text + "完了\r\n"
//DELETEでIN句を使う方法
//https://oreno-it.info/archives/2982