--- In firebird-support@yahoogroups.com, "Arno Brinkman"

> As notice by david your query runs a cartesian product this is due

how you use the aliases. (This is

> fixed in FB2)
> Anyway, if you use an alias for a table use them for all tables.
>
> SELECT
> S2.userid,
> S2.groupid,
> S1.username
> FROM
> S S1
> JOIN S S2 ON (S2.userid = S1.userid)
> WHERE
> S1.groupid = '004'

Thanks very much!!! That worked great. Never would have guessed it.