Ed Dressel wrote:

>> select 1 from DetailInfo d where ...
>
> what does the '1' do in this SQL?

'1' is a usually used when you want to select 'anything'. You can use
42, 'aaa', or any other value - you just need something in the SELECT list.

--
Milan Babuskov
http://www.flamerobin.org