Ask Question

If you are attempting to join two tables that have multiple common columns, which of the following JOIN keywords should be used to specify how the tables should be linked?

1. outer join

2. join ... using

3. cross join

4. none of the above

+2
Answers (1)
  1. 15 March, 22:22
    0
    Join ... using keywords should be used to specify how the tables should be linked.

    2. join ... using

    Explanation:

    If table is has to be linked it can be connected normally as outer join with same column name.

    Purpose of outer join is to fetch the matched records among the table and get the relevant records from table.

    People can also use select statement with "IN" sub query, if we use "IN" query execute very slow during the fetching the matched records.

    As good practice join using is used in same column name is available across the table.

    By using join using in query end user can set some query conditions also.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “If you are attempting to join two tables that have multiple common columns, which of the following JOIN keywords should be used to specify ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers