Subject | using clause |
---|---|
Author | firebirdsql |
Post date | 2011-09-24T15:57:38Z |
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);
EX:
SELECT username FROM users INNER JOIN
(SELECT poster_username AS username FROM test) USING(username);