Question

SQL INNER JOIN 时，如果连接了多个表，解析时的顺序是怎样的？

SELECT vbak~vbeln vbak~vkgrp vbak~audat vbak~auart vbak~kunnr vbak~knumv

vbap~posnr vbap~pstyv vbap~matnr vbap~arktx vbap~vrkme vbap~cmpre
vbap~kwmeng vbap~kzwi1 vbap~meins vbap~umvkz vbap~umvkn vbap~zmeng

INTO CORRESPONDING FIELDS OF TABLE t_total[]
FROM vbak
INNER JOIN vbap ON vbap~vbeln = vbak~vbeln " 1
INNER JOIN lips ON lips~vgbel = vbap~vbeln "2
AND lips~vgpos = vbap~posnr
INNER JOIN vbup ON vbup~vbeln = lips~vbeln "3
AND vbup~posnr = lips~posnr

INNER JOIN knvv ON knvv~kunnr = vbak~kunnr "4
AND knvv~vkorg = vbak~vkorg
AND knvv~vtweg = vbak~vtweg
AND knvv~spart = vbak~spart.
如上语句，SQL在解析的时候是按照什么样的顺。4-3-2-1 还是 1-2-3-4？

Answer 1

4-3-2-1

追问

SELECT * INTO TABLE gt_kunn2 FROM knvp
WHERE kunnr IN s_kunnr AND "1
vtweg IN s_vtweg AND "2
spart IN s_spart AND "3
parvw = 'ZB' AND "4
vkorg IN s_vkorg. "5
如上语句，在where条件中的5个项目中。SQL在解析的时候是按什么顺：1-2-3-4-5.，还是5-4-3-2-1？
谢谢~~

追答

1-2-3-4-5

Answer 2

顺序吧

Answer 3

111111111