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.
>
>Jason
>
>

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
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
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