SQL Query from 3 linked tables is ignoring the WHERE clause

[Guest]

I have a query using 3 linked (LEFT JOIN) SQL tables in Access 2000. The
query runs but completely ignores whatever filters I try to build into the
WHERE clause. I'm stumped!

 

[John Vinson]

On Mon, 30 Jan 2006 19:47:30 -0800, "Paul Ambler" <Paul

I have a query using 3 linked (LEFT JOIN) SQL tables in Access 2000. The
query runs but completely ignores whatever filters I try to build into the
WHERE clause. I'm stumped!

I suspect you need to include

OR IS NULL

on the criteria of any of the "child" tables, or you defeat the
purpose of the left join.

Could you perhaps post the SQL of the query? It's a bit hard to see it
from here...

John W. Vinson[MVP]