What is true about joining tables through an equijoin? - ProProfs Discuss
Advertisement

What is true about joining tables through an equijoin?

What is true about joining tables through an equijoin?<br/>

Change Image    Delete

This question is part of Oracle_Test7
Asked by Sudha_test, Last updated: Oct 18, 2020

+ Answer
Request
Question menu
Vote up Vote down

2 Answers

M. Krasinski

M. Krasinski

M. Krasinski
M. Krasinski, Content Writer, Columbus

Answered Jul 20, 2018

You can join n tables (all having single column primary keys) in an SQL statement by specifying a minimum of n-1 join conditions. The columns in the join condition should coincide with each other. If in case there are some differences, then there may be issues in joining the columns together.

If you want to perform EQUI JOIN, you can also use the keyword JOIN then follow that with ON so that the columns that you have chosen will be checked if they are equal with each other. If they are found to be equal, then they would be matched and mixed well.

upvote downvote
Reply 

John Smith

John Smith

John Smith
John Smith

Answered Mar 10, 2017

You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.