Subject using clause
Author firebirdsql
How can I use the using clause on a join between two tables that have diff column names? Do I have to use a derived table to rename the columns first?

EX:
SELECT username FROM users INNER JOIN
(SELECT poster_username AS username FROM test) USING(username);