What is equivalent to Oracle's "inner join using" in MS Access?
Posted on 2005-04-27
Oracle provides a way to do the inner join such that the common columns in the joined tables are not repeated in the target table, prepended by the joining table names. I know that this can be done with the "using" clause (instead of the ON clause) in conjunction with the inner join . For instance,
select tab1.*, tab2.* from tab1 inner join tab2 using (common_column);
would produce a table with common_column as one of the columns.
select tab1.*, tab2.* from tab1 inner join tab2 using (tab1.common_column = tab2.common_column);
would produce a table with tab1.common_column and tab2.common_column as two separate columns.
I am trying to implement an inner join on two tables in an Access database which simulates the "using" clause of Oracle (non repeated common column names in the target table).
Is there a way to do this. Any help would be greatly appreciated.