Stop query after first match

2002-03-14 Thread Egor Egorov
Danny, Wednesday, March 13, 2002, 2:30:10 PM, you wrote: DK> I'd like to know how I can do the following: DK> I want to query a single table like this: DK> select field1, field2, field3 from table1 where field1='something' and DK> field2=0; DK> This query will result in more then one match. I

Stop query after first match

2002-03-13 Thread Danny Kruitbosch
Hi, I'd like to know how I can do the following: I want to query a single table like this: select field1, field2, field3 from table1 where field1='something' and field2=0; This query will result in more then one match. It's not possible for me to use a more specific query. From the result I