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);
