我有一个基本的Windows表单应用程序,它连接并显示数据库。我想使用两个表中的信息更新其中一个数据库。
UPDATE account AS a
SET accrued = (a.accrued + ((p.intrate/365)*balance))
FROM customer c JOIN product p
ON p.prodid = a.prodid
WHERE c.custid = a.custid AND active = 1
这在数据库浏览器中有效。
using (SQLiteCommand cmd = connAccount.CreateCommand())
{
// adds customers details to the database
cmd.CommandText = @"UPDATE account AS a SET accrued = (a.accrued + ((p.intrate / 365) * balance)) FROM customer c JOIN product p ON p.prodid = a.prodid WHERE c.custid = a.custid AND active = 1";
cmd.ExecuteNonQuery();
MessageBox.Show("Daily Accrued Updated");
}
在我的应用程序中,这个错误提示:
System.Data.SQLite.SQLiteException:'SQL逻辑错误, 靠近 "FROM":语法错误'