UPDATE ziliao1 ziliao2 SET young="yes" WHERE age="25"
UPDATE ziliao1 ziliao2 SET young="yes" WHERE age="25"
我有一个数据库有ziliao1 ziliao2两个表单其中ziliao1中有字段young
ziliao2中有字段age
我想用实现把满足 ziliao2中age="25"的纪录的ziliao1中的young更改为"yes"
下边的语句好像不能实现,请教高手!
CDatebase db1
CString sql.Format("UPDATE ziliao1 ziliao2 SET young='yes' WHERE age='25'")
db1.openEx(_T("test"),0);
db1.ExecuteSQL(sql);