I am trying to create a SQL query from Baan table tfgld008 (Trial Balance) to pull out the ledger account, opening balances, closing balances etc. When I run select * from baandb.ttfgld008 it just gives me the ledger and description etc with no amounts. How do I go about pulling through all the balances? I can see the details in table tfgld3501s000 (Ledger History) but the attributes all revert back to tfgld008.
Any help would be much appreciated….I am very very new to SQL.
:confused::)

Welcome to the board.

The values being displayed are just form fields. The original values are calculated using business logic.

You use data in tables - tfgld201,tfgld202,tfgld202....212 for getting the required values.