Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Weird result. I can't get what I want from my select
Message
From
05/06/2008 17:37:52
 
 
To
05/06/2008 17:36:14
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01321989
Message ID:
01321991
Views:
13
>>I do a select sql based on a condition for a certain field and it works ok
>>
>>I do a big select with many joins and at the end of that select I add where. That where is based on the first condition that worked (when used alone) and nothing comes out of that query.
>>
>>Anyone could help me on that?
>
>Are you using INNER JOINs? You probably need LEFT OUTER JOINs.

I will look at that. Thx
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform