>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