كيف ازيل التكرار من جملة SQL تربط بين جدولين Meal و Patient بعلاقة Many to Many
SELECT DISTINCT Patient.Name, Patient.USER_FILE_ID, Patient.WARD, Meal.HighProtein, Meal.LowProtein, Meal.Diabetic, Meal.LowSalt, Meal.LowFat, Meal.Soft, Meal.UIcer, Meal.Comment, Meal.OPD, Meal.Fasting, Meal.D_C, Meal.Trans, Meal.Meat, Meal.Fish, Meal.Chicken, Meal.DryFood FROM Patient LEFT JOIN (Meal RIGHT JOIN Meal_Patient ON Meal.MealID = Meal_Patient.MealID) ON Patient.USER_FILE_ID = Meal_Patient.USER_FILE_ID WHERE (Patient.WARD = @WARD)">