怎么这个select语句会select出两条相同的记录

[andrew_zx]

select c.callid_master,do.id, c.start_Time, c.ani, c.calling_Device, c.callee_Device, c.answer_Duration,
c.call_Type, c.ani_Area FROM Call_Master as c, Device_Info do
WHERE c.answer_Duration=0 AND c.call_Type in (1,3)
AND do.device = c.callee_Device and ((do.device =8760))
order by c.start_Time

[-狙击手-]

那表明你的表中确实有相同的记录呀或是其中　有一个表有相同的记录，而且和另一个表还存在关联值

[bqb]

Call_Master 含有 2条 callee_Device=8700的记录
或者
Device_Info 含有 2条 device =8760的记录