View Single Post
Old 4th July 2017, 12:21
jojanna jojanna is offline
Join Date: Jul 2017
Posts: 1
jojanna is on a distinguished road
Baan: Baan V - DB: None - OS: Windows
SQL Help tfgld008
Baan: Other/Unknown

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.
Reply With Quote