mahlake
چهارشنبه 28 بهمن 1394, 09:47 صبح
سلام بنده یک کد یکسان رو در دو دیتابیس ظاهرا یکسان اجرا میکنم اما تو یکی از دیتا بیسا نتیجه ای نمیده دلیل چیه؟ خیلی فوری...
SELECT sanad.id, colleague.cname, rclient.rname, sanad.plk, sanad.shs, sanad.odt, sanad.gng, sanad.shsh, sanad.shm, sanad.tvd, colleague.dct, sanad.clr, sanad.cpn, sanad.mob, sanad.shb, sanad.dtv, sanad.pnb,
sanad.dcb, colleague.mnc, colleague.tnc, rclient.frn, rclient.rsh, rclient.rcn, rclient.ptlc, rclient.[add], rclient.rtn, sanad.gpn, sanad.dcs, sanad.dgd, sanad.emza
FROM sanad FULL OUTER JOIN
colleague ON sanad.cid = colleague.cid FULL OUTER JOIN
rclient ON sanad.rid = rclient.rid
WHERE (sanad.plk LIKE N'%123%')
SELECT sanad.id, colleague.cname, rclient.rname, sanad.plk, sanad.shs, sanad.odt, sanad.gng, sanad.shsh, sanad.shm, sanad.tvd, colleague.dct, sanad.clr, sanad.cpn, sanad.mob, sanad.shb, sanad.dtv, sanad.pnb,
sanad.dcb, colleague.mnc, colleague.tnc, rclient.frn, rclient.rsh, rclient.rcn, rclient.ptlc, rclient.[add], rclient.rtn, sanad.gpn, sanad.dcs, sanad.dgd, sanad.emza
FROM sanad FULL OUTER JOIN
colleague ON sanad.cid = colleague.cid FULL OUTER JOIN
rclient ON sanad.rid = rclient.rid
WHERE (sanad.plk LIKE N'%123%')