Actually, as Naomi pointed out, ISNULL() for SQL Server is basically the equivalent of NVL(). Switching between queries for VFP and SQL has been messing me up lately! I thought it was bad enough switching between VFP and Delphi (as I used to do). :o)



>I see Sergey and Chad have given you working code. FWIW I suspect the ISNULL() was messing you up. Wouldn't that be NVL() instead? If nothing else, ISNULL() returns a logical value.
>
>
>>Passing the query to SQL2000/SQL2005,
>>
>>Goal:
>>
>>1. I want to pull ALL of the records in table1 where not_in_srv = 1 regardless
>>2. Include matching records in table2 IF any exist (some table1 records will have a matching record in table2 and some will not) the link is hydr_id in both tables
>>

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