Subject Re: [firebird-support] Query Madness!
Author Alexandre Benson Smith
Jason Dodson wrote:

>This was a copy/paste problem. It DOES NOT show up in the "Inner Join"
>query. It DOES show up in the "Left Join" query.
Don't know about your data, but the "left outer join" tend to present
more records than the "inner join"

If you are sure that you will have a matching record on the right table,
so the inner and the outer join should return the same data, why do you
need the outer join ?

I'm thinking I missed some point...

see you !


Alexandre Benson Smith
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil

No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.13 - Release Date: 16/04/2005