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