Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combining two tables
Message
From
27/07/2012 10:16:12
Marcia Akins
Arkansas, United States
 
 
To
27/07/2012 09:59:21
Steve Tysinger
Elizabeth Carbide of Nc.C
North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Combining two tables
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01549418
Message ID:
01549423
Views:
56
I am combinging two tables T1 & T2 they have customer numbers/Custno and quarter sales totals/qs

T1 contains data for the year 2010 T2 contains data from the year 2011
SELECT NVL(T1.CustNo, T2.custno), T2.QS as 2011_QS, T1.QS as 2010_QS
FROM Table1 T1 FULL OUTER JOIN Table2 T2 ON T1.CustNo = T2.CustNo
Previous
Reply
Map
View

Click here to load this message in the networking platform