Ok. I hope I can clear this out.
Please don't abandon me.
The first think that puzzles me here is:
We are doing a:
However, neither rebromung, or dippflesob, belongs to frabilgimjer table.
I can arrange the sintax for reading proposes only like so:
FROM frabilgimjer INNER JOIN quistipunctous
Where the from is no longer frabilgimjer BUT frabilgimjer inner joined with quistipunctous.
Still however, rebromung and dippflesob don't have a match.
They only appear here:
ON quistipunctous.scrimflabat = frabilgimjer.horbliston
ON haplistplogget.opsilfrummer = quistipunctous.whipfintaggle
Now, they do have a match.
From here, I can understand that we are actually joining three tables.
I can also tell that:
frabilgimjer is joined with quistipunctous
And quistipunctous is joined with haplistplogget
Then, forcefully, frabilgimjer will be joined with haplistplogget (is this correct, I miss my basic Aristotelian logic :s);
If all the above are correct deductions:
Why do we need a specific column to join tables?
Why can't we just say, Join TableA with TableB no matter where they join ?
Thanks a lot in advance,