Database

SELECT * FROM table1, table 2 WHERE table1.id = table2.id;

SELECT [TABLE_NAME]
      ,[COLUMN_NAME]
  FROM [INFORMATION_SCHEMA].[COLUMNS]
  where TABLE_NAME = <your_temp_view>

sys.columns (Transact-SQL) - SQL Server | Microsoft Docs[^]:

Column IDs might not be sequential.

SELECT [name], ROW_NUMBER() OVER (ORDER BY [column_id]) As [Ordinal]
FROM sys.columns
WHERE [object_id] = OBJECT_ID('MyTable')
ORDER BY [column_id]

Member 14006806 wrote:

Creditor documents cover debtor documents.

Quote:

Creditor documents cover debtor documents.

select personID, DocDate, DocID, (-1) * Fee As Fee, IsDebit
from #debit
union all
select personID, DocDate, DocID, Fee, ISDeb
from #credit

;with combine as 
(
	select personID, DocDate, DocID, (-1) * Fee As Fee, IsDebit
	from #debit
	union all
	select personID, DocDate, DocID, Fee, ISDeb
	from #credit
)
,CTE
as
(
    select T.personID, T.DocDate, T.DocID, T.Fee, T.Fee as running_total
    from combine as T
    where T.DocID = 1
    union all
    select T.personID, T.DocDate, T.DocID, T.Fee, T.Fee + C.running_total as running_total
    from CTE as C
        inner join combine as T on T.DocID = C.DocID + 1
)
select C.PersonID, C.DocDate, C.DocID, C.Fee, C.running_total
from CTE as C

PersonID	DocDate	DocID	Fee	running_total
88		2/14		1	-5		-5
88		2/15		2	-5		-10
88		2/16		3	3		-7
88		2/17		4	7		0