programerinfonet
چهارشنبه 16 مرداد 1392, 18:06 عصر
سلام من از یک جدول چند تا select گرفتم و حالا میخوام همه رو باهم ادغام کنم و توی دیتاگرید نشون بدم چه طور این کار رو بکنم ؟
دستور select 1
SELECT People.PName, People.PID, People.PDate, Document.DCaption, People.PAccount, People.PDiagnosis FROM People INNER JOIN Document ON People.PID = Document.DPeople WHERE (((Document.DocType)="اشخاص")) GROUP BY People.PName, People.PID, People.PDate, Document.DCaption, People.PAccount, People.PDiagnosis;
دستور select 2
SELECT Document.DocType, People.PName, DonChq.DID, DonChq.DDate, Document.DCaption, DonChq.DAmount, Document.DDiagnosis FROM People INNER JOIN (DonChq INNER JOIN Document ON DonChq.DID = Document.DNo) ON People.PID = Document.DPeople WHERE (((Document.DocType)="دریافت چک")) GROUP BY Document.DocType, People.PName, DonChq.DID, DonChq.DDate, Document.DCaption, DonChq.DAmount, Document.DDiagnosis;
ممنون میشم کمکم کنید
دستور select 1
SELECT People.PName, People.PID, People.PDate, Document.DCaption, People.PAccount, People.PDiagnosis FROM People INNER JOIN Document ON People.PID = Document.DPeople WHERE (((Document.DocType)="اشخاص")) GROUP BY People.PName, People.PID, People.PDate, Document.DCaption, People.PAccount, People.PDiagnosis;
دستور select 2
SELECT Document.DocType, People.PName, DonChq.DID, DonChq.DDate, Document.DCaption, DonChq.DAmount, Document.DDiagnosis FROM People INNER JOIN (DonChq INNER JOIN Document ON DonChq.DID = Document.DNo) ON People.PID = Document.DPeople WHERE (((Document.DocType)="دریافت چک")) GROUP BY Document.DocType, People.PName, DonChq.DID, DonChq.DDate, Document.DCaption, DonChq.DAmount, Document.DDiagnosis;
ممنون میشم کمکم کنید