نحوه گزارش گيري از 4 جدول

[sajjad_kochekian]

من چهار جدول دارم كه مي خواهم از آنها گزارش تهيه كنم.
ولي هر select كه از آن مي گيريم ركورد هاي در هم تكرار ميشن.
من يك فيلد به نام كد در هر چهار جدول دارم.
يكي از آن چهار جدول مستر هست با نام document
سه جدول ديگه زير مجموعه آن هستند.
اگر ميشه يك راهنمايي كنيد

[بهزادصادقی]

لطفا ساختار جداول خود و متن یکی از select هایی که باهاش مشکل داری را اینجا درج کن.

[sajjad_kochekian]

اين هم دستور
فيلد Document.Code كليد رابط بين سه جدول ديگر با نام Codes


SELECT Document.Code, Document.Period, Document.F_kind, Document.F_workshop, Document.F_CustomerCode,
Document_Amount.F_ProductCode, Document_Amount.M1 AS aM1, Document_Amount.M2 AS aM2,
Document_Amount.M3 AS aM3, Document_Amount.M4 AS aM4, Document_Amount.M5 AS aM5, Document_Amount.M6 AS aM6,
Document_Amount.M8 AS aM8, Document_Amount.M7 AS aM7, Document_Amount.M9 AS aM9,
Document_Amount.M10 AS aM10, Document_Amount.M11 AS aM11, Document_Amount.M12 AS aM12,
Document_Rate.M1 AS rm1, Document_Rate.M2 AS rm2, Document_Rate.M3 AS rm3, Document_Rate.M4 AS rm4,
Document_Rate.M5 AS rm5, Document_Rate.M6 AS rm6, Document_Rate.M7 AS rm7, Document_Rate.M8 AS rm8,
Document_Rate.M9 AS rm9, Document_Rate.M10 AS rm10, Document_Rate.M11 AS rm11, Document_Rate.M12 AS rm12,
Document_Price.M1 AS pm1, Document_Price.M2 AS pm2, Document_Price.M3 AS pm3, Document_Price.M4 AS pm4,
Document_Price.M5 AS pm5, Document_Price.M6 AS pm6, Document_Price.M7 AS pm7, Document_Price.M8 AS pm8,
Document_Price.M9 AS pm9, Document_Price.M10 AS pm10, Document_Price.M11 AS pm11,
Document_Price.M12 AS pm12
FROM Document FULL OUTER JOIN
Document_Price ON Document.Code = Document_Price.Codes FULL OUTER JOIN
Document_Amount ON Document.Code = Document_Amount.Codes FULL OUTER JOIN
Document_Rate ON Document.Code = Document_Rate.Codes
WHERE ( Document.Code = @code)

[بهزادصادقی]

مرسی.

ولی شما ساختار جداول خود را درج نکردید.