At 01:42 PM 20/01/2004 +0000, you wrote:

>Thanks Helen for your answer - great info. Maybe do you have some
>links/info about cursors in queries & etc - DB is not my region of
>programming specialization, but see, that need to gain more knowledge ;)

In this context a "cursor" is just a convenient way to visualise a record
pointer "moving" through a set. If you subquery the same table three times
for each main row (as in your example) you need to have three independent
record pointers. You use the three different table aliases to distinguish
the references to each pointer.

- although SQL does have ways to declare a cursor explicitly. And I'm not
writing a tutorial on it right now...

>Yes, I'm working with the unicode charset (as it's the only one can
>store lithuanian characters without conversion error)

Doesn't ISO8859_13 work for you?

>- so set default
>DB character set to Unicode_FSS. If I understood right, that to write
>character sets in such scenario isn't neccessary

As I understand it, you do need to specify it for variables and search
arguments. But I suppose the thing to do would be to try it without and
see whether it works...

/hb