How do you say it in SQL? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How do you say it in SQL?

Message

De

02/09/2008 13:28:18

Edward Pikman
Independent
New York City, New York, États-Unis

À

02/09/2008 13:24:57

Randy Waldman
Hoffer Companies
Houston, Texas, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

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

Titre:

Re: How do you say it in SQL?

Versions des environnements

Visual FoxPro:

VFP 7 SP1

OS:

Windows XP SP2

Network:

Windows 2000 Server

Database:

Visual FoxPro

Divers

Thread ID:

01344218

Message ID:

01344219

Vues:

14

>Hi. How would you say in a sql command
>
>

>IF there is not a matching value in the table, use '00000'
>

>
>Thanks, Randy

If I understand 'matching value' correctly,
Select NVL(table2.field1,'00000') From table1 Left Outer Join table2 On ....

Edward Pikman
Independent Consultant

Click here to load this message in the networking platform