SELECT * FROM table1 LEFT JOIN table2 ON table2.hydr_id = table1.hydr_id ; WHERE table1.not_in_srv = 1>Passing the query to SQL2000/SQL2005,
>SELECT * FROM table1 INNER JOIN table2 ON table2.hydr_id = table1.hydr_id ; > WHERE (ISNULL(table1.not_in_srv,0) = 1) >>I keep getting strange results.