--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:

> If the ordering is essential, how does this one go?

That works beautifully except that there may be multiple corresponding
records in ITEMINFORMAT which is why I was using the joins otherwise I
get an error saying 'multiple rows in singleton select'

Mark