SQL Query from 3 linked tables is ignoring the WHERE clause

P

Paul Ambler

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

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!
Click to expand...

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