SELECT '' As RecMarker, UserPK_COA, ([TITLE_COA]+' - ' + [DESCRIPTION_INVTY]+' - ' + [NAME_UM]) AS DESCRIPTION, UserFK_GenericClass_LdgrEntries, Title_COA, UserPK_UM, Name_UM, UserPK_TransH, ModuleType_TransH, DateIssue_TransH, DRAmount_LdgrEntries , DRAmountPDC_LdgrEntries, CRAmount_LdgrEntries , CRAmountPDC_LdgrEntries, ModuleTrans_LdgrEntries, Particulars_LdgrEntries, DateDue_LdgrEntries, Module_LdgrEntries, [Transaction_Ledger_Entries].[UserSeq_LdgrEntries], SysSeq_LdgrEntries, [Transaction_Ledger_Entries].[SysPK_LdgrEntries], [Transaction_Ledger_Entries].[SysFK_TransH_LdgrEntries], SysFK_TransHSL_LdgrEntries, SysFK_LdgrEntriesSL_LdgrEntries, SysFK_UM_LdgrEntries, SysFK_COA_LdgrEntries, SysFK_Invty_LdgrEntries, LastUpdatedConcurrencyID_LdgrEntries, LastUpdatedDate_LdgrEntries, LastUpdatedBy_LdgrEntries, AddIfSide_COA, HasUMSL_COA, HasInvtySL_COA, AmountDue_LdgrEntries, UsualDue_LdgrEntries, ArrearsDue_LdgrEntries, BalanceClr_LdgrEntries, BalancePDC_LdgrEntries, DRBaseUnitQty_LdgrEntries, CRBaseUnitQty_LdgrEntries, Status_LdgrEntries, Type_COA FROM ((((Transaction_Ledger_Entries LEFT JOIN COA_Master2 ON Transaction_Ledger_Entries.SysFK_COA_LdgrEntries = COA_Master2.SysPK_COA) LEFT JOIN Universal_Master2 ON Transaction_Ledger_Entries.SysFK_UM_LdgrEntries = Universal_Master2.SysPK_UM) LEFT JOIN Transaction_Header ON Transaction_Ledger_Entries.SysFK_TransHSL_LdgrEntries = Transaction_Header.SysPK_TransH) LEFT JOIN CBD_Master2 ON Transaction_Header.CBD_TransH = CBD_Master2.SysPK_CBD) LEFT JOIN Inventory_Master2 ON Transaction_Ledger_Entries.SysFK_Invty_LdgrEntries = Inventory_Master2.SysPK_Invty WHERE [Transaction_Ledger_Entries].[SysFK_TransH_LdgrEntries] = 284105672805023 AND [Transaction_Ledger_Entries].[SysFK_TransH_LdgrEntries] <> 0 ORDER BY DRAmount_LdgrEntries DESC , CRAmount_LdgrEntries DESC
Yan yong sa aking nag program kasi ako ngayon hehehehehhe