Anonymous wrote: Because, this is just part of my query, if I use top 1, then, I can't get other entries required by some other conditions. Use the Top 1, you can use the UNION statement to make multiple selects like this to match all of your criteria:
SELECT a, b, c, d FROM table_one WHERE a = 5
UNION
SELECT a, b, c, e FROM table_one WHERE a = 6
UNION
SELECT a, b, c, f FROM table_one WHERE a = 7
UNION
SELECT a, b, c, g FROM table_one WHERE a = 8
HTH :) Nick Parker
**The goal of Computer Science is to build something that will last at least until we've finished building it. - Unknown
**