Skip to Content
Former Member
Sep 03, 2013 at 11:54 AM

Need Help


How To Insert BP Name in this Query?

SELECT T1.[RcptNum] AS 'Receipt Number', T1.[RcptDate] AS 'Receipt Date', T1.[CardCode] AS 'Customer Code', T1.[CheckNum] AS 'Check Number', T1.[CheckSum] AS 'Check Amount', T1.[Deposited] AS 'Deposited', T1.[DpstAbs] AS 'Payment Internal ID', T0.[DeposNum] AS 'Payment No.', T0.[DeposDate] AS 'Payment Date' FROM [dbo].[ODPS] T0 right JOIN [dbo].[OCHH] T1 ON T1.[DpstAbs] = T0.[DeposId]