hai,

i tried these queries in sql 2000. All queries returns the same answer.

Verify ur tables in column ID has null values.

To my knowledge first and third are correct queries...

but...