14-03-19, 12:10 PM
السلام عليكم عندي اربع جداول بال sql server l بينهم علاقة ون تو مني بس عند العرض يطلع عندي تكرار بالصفوف شلون الغي التكرار
هذا الكود
SELECT dbo.Thesuit.id_suit, dbo.Complainant.Thesuit_id, dbo.Complainant.id_name_Complainant, dbo.The_accused.id_name_accused, dbo.legal_article.legal_article
FROM dbo.Thesuit JOIN
dbo.Complainant ON dbo.Thesuit.id_suit = dbo.Complainant.Thesuit_id JOIN
dbo.The_accused ON dbo.Thesuit.id_suit = dbo.The_accused.Thesuit_id1 JOIN
dbo.legal_article ON dbo.Thesuit.id_suit = dbo.legal_article.Thesuit_id5
هذا الكود
SELECT dbo.Thesuit.id_suit, dbo.Complainant.Thesuit_id, dbo.Complainant.id_name_Complainant, dbo.The_accused.id_name_accused, dbo.legal_article.legal_article
FROM dbo.Thesuit JOIN
dbo.Complainant ON dbo.Thesuit.id_suit = dbo.Complainant.Thesuit_id JOIN
dbo.The_accused ON dbo.Thesuit.id_suit = dbo.The_accused.Thesuit_id1 JOIN
dbo.legal_article ON dbo.Thesuit.id_suit = dbo.legal_article.Thesuit_id5