Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL To select from Multiple Tables
Message
From
29/03/2013 08:47:46
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01569456
Message ID:
01569523
Views:
58
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform