>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
http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.