Combining two tables - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Combining two tables

Message

27/07/2012 10:16:12

Marcia Akins
Arkansas, États-Unis

27/07/2012 09:59:21

Steve Tysinger
Elizabeth Carbide of Nc.C
Caroline du Nord, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: Combining two tables

Versions des environnements

Visual FoxPro:

VFP 9 SP2

OS:

Windows 7

Network:

Windows 2008 Server

Database:

Visual FoxPro

Application:

Desktop

Divers

Thread ID:

01549418

Message ID:

01549423

Vues:

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

Répondre

Fil

Voir

Click here to load this message in the networking platform