select * from kadesign,kamem where kadesign.userId=10 AND kamem.userId =kadesign.userId AND kadesign.memId='15' order by reqDate desc对不起,还是出现双倍的重复,即一条记录被查询两次!!!请问:是哪儿出了问题!????
--符合条件的记录有重复,改用:select distinct * from kadesign,kamem where (kadesign.userId=10 AND kamem.userId =10 AND kadesign.memId='15') order by reqDate desc
To zjcxc(邹建) :"符合条件的记录有重复"不是符合条件的记录有重复,而确实是同一条记录被查询两次,结果就在屏幕上输出两次!!!我认为跟查询条件有关!!!但不知道解决办法!!!遇到这样的问题太有意思了卡!!!!
用distinct关键字! select distinct * from kadesign,kamem where (kadesign.userId=kamem.userId =10 AND kadesign.memId='15') order by reqDate desc
select * from kadesign Cross Join kamem where (kadesign.userId=10 AND kamem.userId =10 AND kadesign.memId='15') order by reqDate desc试试!
select * from kadesign,kamem where kadesign.userId=10 AND kamem.userId =kadesign.userId AND kamem.memId='15' AND kadesign.memId='15' order by reqDate desc 我有加一个条件判断!!!问题解决了,谢谢大家!!
where (kadesign.userId=10 AND kamem.userId =10 AND kadesign.memId='15')
order by reqDate desc
select distinct * from kadesign,kamem where (kadesign.userId=kamem.userId =10 AND kadesign.memId='15') order by reqDate desc
select * from kadesign Cross Join kamem where (kadesign.userId=10 AND kamem.userId =10 AND kadesign.memId='15') order by reqDate desc试试!
提交人 管理员
28 fdafdsfdsaf dsfasd ggfda 2003/11/5 2003-11-5
~2003-11-7 aaa bbb ccc 已确认 已确认
28 fdafdsfdsaf dsfasd ggfda 2003/11/5 2003-11-5
~2003-11-7 aaa bbb ccc 已确认 已确认
27 “网络与发展”论坛 Austin 2003/11/5 2003-11-6
~2003-11-16 “网络与发展”论坛--设计方案 已确认 已确认
27 “网络与发展”论坛 Austin 2003/11/5 2003-11-6
~2003-11-16 “网络与发展”论坛--设计方案 已确认 已确认
这就是输出的数据!!!!这样看有点乱,但它确实是同一条记录输出两次啊!!
这种问题最近经常遇到,决非偶然!!
我个人认为是对一条记录查询了两次!!!
我有加一个条件判断!!!问题解决了,谢谢大家!!