Re: Please Help with outer join syntax...

Art S. Kagel wrote: > Actually David the Informix syntax you use for outer join IS ANSI > compliant, it is just compliant with the oldest ANSI spec for outer > join. > > Note, however, that the latest versions of Informix, IDS 7.31 and > later, > support the ANSI 92 syntax including the "ON" clause which permits > filtering on the NULL results columns. By the way, any query that > returns > no rows if the dependent table has not matching row is an INNER join > NOT > an OUTER join. Outer joins, by definition, return a NULL row for any > row > not matched. > Art, Thanks, this has confused me for sometime. So are you saying that I should replace my OUTER with INNER? ----- David M. Davisson davisson@pfp.net