السلام عليكم ورحمة الله
عندي جدولين
الاول Family والثاني Orphans
ومرتبطان عن طريق حقل ID
اريد اظهار جميع الحقول في الجدول دون تكرار النتائج
جربت استخدام Distinct ولكن
ما ظبطت معايا
جملة الاستعلام هي :
**************************************************************
SELECT DISTINCT
Family.ID, Family.BranchID, Family.RegionID, Family.FamilyNo, Family.Address, Family.Phone, Family.Mobile1, Family.Mobile2, Family.Mobile3,
Family.SearcherID, Family.FirstVisitDate, Family.FatherID, Family.FatherName, Family.FatherDiedDate, Family.FatherJob, Family.FatherBirthPlace, Family.Notes,
Family.FirstVisitDate_DateTimeField, Family.xxx, Family.FatherDiedDate_DateTimeField, Family.xxxx, Family.IsBenefit, Family.RegisterationDate,
Orphans.ID AS Expr1, Orphans.OrphanID, Orphans.FamilyID, Orphans.OrphanName, Orphans.OrphanBirthDate, Orphans.OrphanEduStage, Orphans.OrphanEduRow,
Orphans.OrphanHealthStatus, Orphans.OrphanDisease, Orphans.OrphanContinueTreatment, Orphans.Notes AS Expr2, Orphans.OrphanGender,
Orphans.OrphanIsBenefit, Orphans.OrphanDiseaseId, Orphans.OrphanBirthDate_DateTimeField
FROM Family LEFT OUTER JOIN
Orphans ON Family.ID = Orphans.FamilyID
WHERE (Family.ID > '1') AND (Orphans.OrphanDiseaseId = 10)
**********************************************************
النتائج نظهر كالتالي :
