>>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-JoinsGood answer! This is a straightforward SQL issue. The original poster will learn a lot more from working out the command based on the information in the (excellent) link than he would from someone handing him the answer. If someone posts asking about a more advanced SQL feature, that's one thing, but IMO it does the poster no favors to serve up code for a basic task.