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. It's

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