farshid_82
یک شنبه 15 مرداد 1391, 14:57 عصر
سلام
دوستان میشه لطفا راهنمائی کنید مشکل در قسمت شرط کد زیر چیه
select TR.*,(Select TRIM(PD) From TBL_CATEGORY Where ID = TR.CATEGORY) as NCATEGORY,
(Select SUM(TR2.DBR) - SUM(TR2.CDR) From TBL_TRANSACTIONS TR2 Where TR2.ID <= TR.ID) as HBalance,
IF (TR.R_TAG = "P")
BEGIN
(SELECT NAME FROM TBL_PACCOUNT WHERE ID = TR.CPAYEE) as PName
END
ELSE
IF (TR.R_TAG = "O")
BEGIN
(SELECT NAME FROM TBL_ACCOUNT WHERE ID = TR.CPAYEE) as PName
END
from TBL_TRANSACTIONS TR
ORDER BY TR.ID,TR.SDate
دوستان میشه لطفا راهنمائی کنید مشکل در قسمت شرط کد زیر چیه
select TR.*,(Select TRIM(PD) From TBL_CATEGORY Where ID = TR.CATEGORY) as NCATEGORY,
(Select SUM(TR2.DBR) - SUM(TR2.CDR) From TBL_TRANSACTIONS TR2 Where TR2.ID <= TR.ID) as HBalance,
IF (TR.R_TAG = "P")
BEGIN
(SELECT NAME FROM TBL_PACCOUNT WHERE ID = TR.CPAYEE) as PName
END
ELSE
IF (TR.R_TAG = "O")
BEGIN
(SELECT NAME FROM TBL_ACCOUNT WHERE ID = TR.CPAYEE) as PName
END
from TBL_TRANSACTIONS TR
ORDER BY TR.ID,TR.SDate