Michel,
>In this particular SQL, I cannot just change INNER by LEFT because a WHERE clause is bound to the INNER JOIN clause. How can I modify this SQL to always the record I want from Style.dbf, the one for Style.Numero=1, even if the INNER JOIN is not found?
Wouldn't
> LEFT JOIN StyleDefinition ON Style.Numero=StyleDefinition.NoStyle AND StyleDefinition.NoStyleC=1 ;
> WHERE Style.Numero=1 ORDER BY Title
work?
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges