What is equivalent to Oracle's "inner join using" in MS Access?

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.
EzogAsked:
Who is Participating?
 
jrb1Commented:
0
 
grayeCommented:
It's not the difficult to "translate" the USING keyword

Before:
   select tab1.*, tab2.* from tab1 inner join tab2 using (common_column);
After:
   select tab1.*, tab2.* from tab1 inner join tab2 on tab1.common_column = tab2.common_column;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.