接上题,创建T1和T2表并插入上题T1,T2数据之后执行update T1 set T1.amount1=(select T2.amount2 from T2 where T1.id1=T2.id2)where T1.id1 in (select T2.id2 from T2 where T1.id1=T2.id2);commit;执行之后查看select * from t1 where id1=3;结果是哪个()
主观题
接上题,创建T1和T2表并插入上题T1,T2数据之后执行update T1 set T1.amount1=(select T2.amount2 from T2 where T1.id1=T2.id2)where T1.id1 in (select T2.id2 from T2 where T1.id1=T2.id2);commit;执行之后查看select * from t1 where id1=3;结果是哪个()