Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 479
  • Last Modified:

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.
1 Solution
It's not the difficult to "translate" the USING keyword

   select tab1.*, tab2.* from tab1 inner join tab2 using (common_column);
   select tab1.*, tab2.* from tab1 inner join tab2 on tab1.common_column = tab2.common_column;

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now