SQL语句如下:update bw_topics2 set ImpNo =
(
select ApplyId from bq_quotation a,bw_topics2 b where
a.topicno=b.topicno and b.iscopyright='是'
and b.impno is null and a.inputman ='导入'
)
where iscopyright='是' and impno is null
and TopicNo = (select a.Topicno from bq_quotation a,bw_topics2 b
where a.Topicno = b.TopicNo and b.iscopyright='是' and b.impno is null and a.inputman ='导入');排除了表中有相同的记录,为什么还是会报这样的错误!请各位指教...bw_topics2中的TopicNo是主键
(
select ApplyId from bq_quotation a,bw_topics2 b where
a.topicno=b.topicno and b.iscopyright='是'
and b.impno is null and a.inputman ='导入'
)
where iscopyright='是' and impno is null
and TopicNo = (select a.Topicno from bq_quotation a,bw_topics2 b
where a.Topicno = b.TopicNo and b.iscopyright='是' and b.impno is null and a.inputman ='导入');排除了表中有相同的记录,为什么还是会报这样的错误!请各位指教...bw_topics2中的TopicNo是主键
(
select ApplyId from bq_quotation a,bw_topics2 b where
a.topicno=b.topicno and a.inputman ='导入'
)
where iscopyright='是' and impno is null;
(select 字段列表 from tableb b where a和b的关联条件)
where a的限定条件
a.topicno=b.topicno and b.iscopyright='是'
and b.impno is null and a.inputman ='导入'还是会报同样的错误,郁闷啊。怎么改好呢
(
select ApplyId from bq_quotation a,bw_topics2 b where
a.topicno=b.topicno and b.iscopyright='是'
and b.impno is null and a.inputman ='导入'
)
where iscopyright='是' and impno is null
and TopicNo in (select a.Topicno from bq_quotation a,bw_topics2 b
where a.Topicno = b.TopicNo and b.iscopyright='是' and b.impno is null and a.inputman ='导入');