مهدی رحیم زاده
پنج شنبه 21 خرداد 1388, 00:19 صبح
سلام
اشکال این کد کجاست که نصف داده ها رو نشون نمی ده ؟
بانک Access
SELECT Accounts.AccAutoCode, Accounts.AccNum AS [شماره حساب], TempAccountTypes.AccTypName AS [نوع حساب], Accounts.AccPadName AS [صاحب حساب], Accounts.DeedCode AS [کد قرارداد], TempBranch.BrName AS شعبه, TempBank.BaName AS بانک, TempCity.CtyName AS شهرستان, TempState.StName AS استان, Accounts.Desc_ AS توضیحات
FROM TempAccountTypes INNER JOIN ((((TempBranch INNER JOIN Accounts ON TempBranch.BrAutoCode = Accounts.BrAutoCode) INNER JOIN TempBank ON TempBranch.BaCode = TempBank.BaCode) INNER JOIN TempCity ON TempBank.CtyCode = TempCity.CtyCode) INNER JOIN TempState ON TempCity.StCode = TempState.StCode) ON TempAccountTypes.AccTypCode = Accounts.AccTypCode;
اشکال این کد کجاست که نصف داده ها رو نشون نمی ده ؟
بانک Access
SELECT Accounts.AccAutoCode, Accounts.AccNum AS [شماره حساب], TempAccountTypes.AccTypName AS [نوع حساب], Accounts.AccPadName AS [صاحب حساب], Accounts.DeedCode AS [کد قرارداد], TempBranch.BrName AS شعبه, TempBank.BaName AS بانک, TempCity.CtyName AS شهرستان, TempState.StName AS استان, Accounts.Desc_ AS توضیحات
FROM TempAccountTypes INNER JOIN ((((TempBranch INNER JOIN Accounts ON TempBranch.BrAutoCode = Accounts.BrAutoCode) INNER JOIN TempBank ON TempBranch.BaCode = TempBank.BaCode) INNER JOIN TempCity ON TempBank.CtyCode = TempCity.CtyCode) INNER JOIN TempState ON TempCity.StCode = TempState.StCode) ON TempAccountTypes.AccTypCode = Accounts.AccTypCode;