This is Firebird 1.0, and a Dialect 1 database.

-Joe

At 11:32 PM 8/21/2006, you wrote:

>--- In
><mailto:firebird-support%40yahoogroups.com>firebird-support@yahoogroups.com,
>"Joe Martinez" <joe@...>
>wrote:
> >
> > Oops, nevermind. I figured out the reason. The VENDORPRODUCTS
>table
> > has a STOREID field as well, and so I guess the unqualified STOREID
>in
> > the the "where" clause was causing it to throw out completely the
>rows
> > where the "joined" STOREID from VENDORPRODUCTS was null. I changed
> > the "where" clause to say A.storeid, and that fixed it.
> >
> > I thought I was losing my mind for a minute!
>
>That surprises me. Normally Firebird (1.5 dialect 3) is pretty strict
>on syntax checking and would tell you something like:
>
>---
>SQL error code = -204
>
>Ambiguous field name between table VENDORPRODUCTS and table PRODUCTS
>
>storeid
>
>---
>
>Are you using an older version or different dialect?
>
>You have just made a very good case in favour of this
>strictness.Count yourself lucky that you discovered the error now
>rather than later.
>
>Adam

[Non-text portions of this message have been removed]