sql调用其他表查询到的值作为条件来查询另一个表

update TABLE2 set FPID=FPID-1 WHERE [Fdatetime] >(SELECT Fcreatetime FROM TABLE1 WHERE [FStatus] = '0' AND [FUserID] = '123456') and FupdateID = 177655*注意，子查询的返回结果Fcreatetime 不能是多个值