Are SQL inner joins reflexive?

Asked Jul 26 '16 at 14:25

Active Jul 26 '16 at 14:25

Viewed 110 times

Say you have two tables:

TA
- apk
- b
- a1

TB
- bpk
- b1

is the SQL INNER JOIN statement reflexive in the way, that

SELECT TA.a1, TB.b1 FROM TA INNER JOIN TB ON TA.b = TB.bpk

is equivalent (in the way that the results are the same) to

SELECT TA.a1, TB.b1 FROM TB INNER JOIN TA ON TA.b = TB.bpk

asked Jul 26 '16 at 14:25

niklasfi

3

Yes. order doesn't matter in `INNER JOIN` [**Related Post**](http://stackoverflow.com/questions/9614922/does-the-join-order-matter-in-sql) – 1000111 Jul 26 '16 at 14:26
@1000111 thank you. Flagged this as a duplicate. – niklasfi Jul 26 '16 at 14:47
Similar to the way in which 4*8*7 = 7*4*8 – Strawberry Jul 26 '16 at 15:03
@Strawberry this is why I searched for the term *reflexivity*. It is the reflexivity of the `*` operator, that allows you to randomly permute its arguments. – niklasfi Jul 26 '16 at 15:19

0 Answers0