I have a Table Invoice.DBF that contains Accountno & Invoiceno.
(Account Number is for Once for all and does not change)

The second table is Acountbalance.dbf that contains Accountno, invoiceno and Acntbal (I.e account Balance)

The Third table is Adjamt.dbf that contains Accountno, invoiceno and Adjbal (I.e account Balance)

The Fourth table is Prevbalance.dbf that contains Accountno, invoiceno and prevtbal (I.e account Balance)

The Fifth table is Finalbalance.dbf that contains Accountno, invoiceno and Finaltbal (I.e account Balance)


What would be The SQl that Select all invoceno from INVOICE.DBF based on My Choice say for Example I choose Account No=12345 and gives the report for all invoices having Account No=12345 as

Invoiceno,Acntbal, adjamt,prevbal, Finalbal