update g_cardapply set g_cardapply.g_state='07'
where g_cardapply.g_applyno=g_cardapplydetail.g_applyno
and g_cardapplydetail.g_idcard='3607821987031306231'
这样为什么无法更新,要怎样才能做到呢??
where g_cardapply.g_applyno=g_cardapplydetail.g_applyno
and g_cardapplydetail.g_idcard='3607821987031306231'
这样为什么无法更新,要怎样才能做到呢??
set g_cardapply.g_state='07'
FROM g_cardapplydetail
where g_cardapply.g_applyno=g_cardapplydetail.g_applyno
and g_cardapplydetail.g_idcard='3607821987031306231'
from g_cardapply,g_cardapplydetail
where g_cardapply.g_applyno=g_cardapplydetail.g_applyno
and g_cardapplydetail.g_idcard='3607821987031306231'
g_cardapply
set
g_cardapply.g_state='07'
FROM
g_cardapplydetail
where
g_cardapply.g_applyno=g_cardapplydetail.g_applyno
and
g_cardapplydetail.g_idcard='3607821987031306231'
update g_cardapply set g_cardapply.g_state='07'
from g_cardapply,g_cardapplydetail
where g_cardapply.g_applyno=g_cardapplydetail.g_applyno
and g_cardapplydetail.g_idcard='3607821987031306231'