Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL syntax
Message
From
16/01/2006 13:20:16
Jim Winter
Jim Winter Consulting
Hinesburg, Vermont, United States
 
 
To
16/01/2006 13:10:46
Randy Waldman
Hoffer Companies
Houston, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MySQL
Miscellaneous
Thread ID:
01087249
Message ID:
01087255
Views:
12
>Hi. What would the syntax for a SQL Select be that would:
> "Take all records in Database A, even if there is no match in DBF B"
>
>Thanks, Randy
...
FROM A LEFT OUTER JOIN B ON (Some Condition)
...
Regards,
Jim
Previous
Reply
Map
View

Click here to load this message in the networking platform