- 论坛徽章:
- 0
|
请各位指教:如何用sql语句更新两个表之间的数据,紧急求助~~
我有两个表,DFDL_USER_INFO_02 A和JL_METER_RUNNING02 B其中A中的列USER—ID和B中的USER—NO是一一对应的,我在PB下自动生成了如下语句,结果提示[/img]
SELECT "JL_METER_RUNNING02"."ELEC_TYPE_CODE",
"JL_METER_RUNNING02"."USER_NO",
"JL_METER_RUNNING02"."USER_NAME"
FROM "JL_METER_RUNNING02"
WHERE ( "JL_METER_RUNNING02"."USER_NO" = ( SELECT "DFDL_USER_INFO_02"."USER_ID"
FROM "DFDL_USER_INFO_02" )) AND
( "JL_METER_RUNNING02"."ELEC_TYPE_CODE" <>; ( SELECT "DFDL_USER_INFO_02"."YDXZ_ID"
FROM "DFDL_USER_INFO_02" )) ; |
|