Re: Difference between inner join and join in SQL query

Hi,

For the below statement :-

"They simply are not the same and would give different results
depending on what you want back. "


Does it refer with respect to 'INNER JOIN' and 'JOIN' ?

or does it refer to 'LEFT OUTER JOIN' and 'RIGHT OUTER JOIN ' here ?

Could you please clarify ?


Thanks.





On Fri, 15 Jul 2022 at 22:53, Javier Sanchez <
javiersanchezbarquero@xxxxxxxxx> wrote:

LEFT OUTER JOIN and RIGHT OUTER JOIN are a different thing. The set
theory is the base of those constructs. You need to study set theory.a
little more. They simply are not the same and would give different results
depending on what you want back.

Javier.

El vie, 15 jul 2022 a las 11:18, Sam_L (<lennon_s_j@xxxxxxxxxxx>)
escribió:

Google 'inner join vs join'

On 7/15/2022 12:58 PM, jerry ven wrote:

Hi,

When I join two files based on ' INNER JOIN' or by simply using

'JOIN'

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com