Did you try to copy/paste link into address line of your browser?


>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.