"UPDATE a
SET
Book_Last_Chapater_ID = b.Book_Chapater_ID
from
Book a,
Book_Chapter b
where
a.Book_ID=b.Book_ID
and
b.Book_Chapater_ID=(select top 1 Book_Chapater_ID FROM Book_Chapater WHERE Book_ID = b.Book_ID ORDER BY Book_Chapater_Num DESC)
and
a.Book_ID="+Book_Name.SelectedItem.Value;
SET
Book_Last_Chapater_ID = b.Book_Chapater_ID
from
Book a,
Book_Chapter b
where
a.Book_ID=b.Book_ID
and
b.Book_Chapater_ID=(select top 1 Book_Chapater_ID FROM Book_Chapater WHERE Book_ID = b.Book_ID ORDER BY Book_Chapater_Num DESC)
and
a.Book_ID="+Book_Name.SelectedItem.Value;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货