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