programerinfonet
سه شنبه 30 آبان 1391, 11:59 صبح
با استفاده ازاین کد یک رکورد درتیبل هست اما دردیتاگرید دو رکورد نمایش داده میشه (تکراری)
SELECT sanadcaption.captionid,sanadcaption.regdate,sanadc aption.type,ashkhasgroups.shgroupname,ashkhas.shna me,kalagroups.groupname,kala.name,sanadkala.tedad, sanadkala.fi,sanadkala.mablagh,visitor.visitorname ,sanadcaption.jamekol,sanadcaption.visit FROM sanadcaption INNER JOIN visitor ON visitor.id=sanadcaption.visitor INNER JOIN ashkhas ON ashkhas.id=sanadcaption.ashkhas INNER JOIN ashkhasgroups ON ashkhasgroups.id=sanadcaption.shcod INNER JOIN sanadkala ON sanadkala.sanadid=sanadcaption.captionid INNER JOIN kala ON kala.id=sanadkala.kala INNER JOIN kalagroups ON kalagroups.id=sanadkala.klcod WHERE type='خرید'
مشکل کجاست ؟
SELECT sanadcaption.captionid,sanadcaption.regdate,sanadc aption.type,ashkhasgroups.shgroupname,ashkhas.shna me,kalagroups.groupname,kala.name,sanadkala.tedad, sanadkala.fi,sanadkala.mablagh,visitor.visitorname ,sanadcaption.jamekol,sanadcaption.visit FROM sanadcaption INNER JOIN visitor ON visitor.id=sanadcaption.visitor INNER JOIN ashkhas ON ashkhas.id=sanadcaption.ashkhas INNER JOIN ashkhasgroups ON ashkhasgroups.id=sanadcaption.shcod INNER JOIN sanadkala ON sanadkala.sanadid=sanadcaption.captionid INNER JOIN kala ON kala.id=sanadkala.kala INNER JOIN kalagroups ON kalagroups.id=sanadkala.klcod WHERE type='خرید'
مشکل کجاست ؟