>This is what the view designer is generating
>
>
>SELECT Productos.prod_clase, Productos.prod_num, Dentradas.ent_numdoc,;
> Dentradas.ent_cantidad;
> FROM elsa!productos LEFT OUTER JOIN elsa!dentradas;
> LEFT OUTER JOIN elsa!productos ;
> ON Productos.prod_num = Dentradas.ent_numprod ;
> ON Productos.prod_clase = Dentradas.ent_clase
>
>
>The join page looks like this:
>
>LEFT OUTER JOIN Productos.prod_clase = Dentradas.ent_clase AND
>LEFT OUTER JOIN Productos.prod_num = Dentradas.ent_numprod
>
>As I said the AND doesn't seem to be doing anything to the SQL statement, and has no apparent efect on the result
Actually I never tried to JOIN the same table twice. I think it will not work this way
Did you try
SELECT Productos.prod_clase, Productos.prod_num, Dentradas.ent_numdoc,;
Dentradas.ent_cantidad;
FROM elsa!productos, elsa!dentradas ;
WHERE Productos.prod_num = Dentradas.ent_numprod ;
AND Productos.prod_clase = Dentradas.ent_clase
(as Vlad says) ?
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison