Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do you say it in SQL?
Message
From
02/09/2008 13:28:18
Edward Pikman
Independent
New York City, New York, United States
 
 
To
02/09/2008 13:24:57
Randy Waldman
Hoffer Companies
Houston, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: How do you say it in SQL?
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01344218
Message ID:
01344219
Views:
13
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform