need some help with a sql query

29 Views

Hello how can give me some help making a query?

Ik want to have a table to do a check if a wrong Vat code is used on a transaction

so i need to have:

Vatcode chartoff acount vat amont amont vat date

A2 8010 19 100 010405

this what I did:

SELECT T0.TransId, T0.ShortName, T1.Code,T1.Rate,T0.Debit, T0.Credit,T0.VatAmount, T0.SYSVatSum FROM JDT1 T0, OVTG T1 WHERE T0.Account=8010

who can give me some help?

thanks Jacques