Tried:

select first 30 skip 100 distinct messages.*, msg_to.to_email,
msg_to.to_name, msg_to.to_type
from messages inner join msg_to on (messages.common_id =
msg_to.common_id) order by messages.msg_key asc, msg_to.to_type desc

The problem is still here - only 7 rows returned...

--- In firebird-support@yahoogroups.com, Pavel Menshchikov
<mpn2001@y...> wrote:

> Try explicit joins:
>
> select distinct messages.*, msg_to.to_email, msg_to.to_name,

msg_to.to_type

> from messages
> inner join msg_to on (messages.common_id = msg_to.common_id)
> order by messages.msg_key asc, msg_to.to_type desc
>
>
>
> HTH
> --
> Best regards,
> Pavel Menshchikov
> http://www.ls-software.com