The Link is not active. It's not opening
>>>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>
>Good 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.
Harsh