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

Posted on 2005-04-27
Last Modified: 2012-06-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.
Question by:Ezog
    LVL 25

    Accepted Solution

    LVL 41

    Expert Comment

    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

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now