Mensaje
De
05/06/2008 19:36:14
a
05/06/2008 17:37:52
General information
Foro:
Visual FoxPro
Category:
Bases de datos, tablas, vistas, índices y SQL
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
Visual FoxPro
Miscellaneous
ID de la conversación:
01321989
ID del mensaje:
01322011
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
Don't place conditions on second tables (from the right part) in the WHERE condition because it would make the LEFT JOIN become INNER JOIN.
>>>
>>>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
Don't place conditions on second tables (from the right part) in the WHERE condition because it would make the LEFT JOIN become INNER JOIN.