SELECT DISTINCT
......
FROM /*主表*/
......
INNER JOIN
(
SELECT DISTINCT
......
FROM ...... GROUP ......
) AS E2
ON ..... = .....
INNER JOIN
( SELECT *
FROM ......
) AS ...
ON ......= ......AND ......
LEFT OUTER JOIN
(
SELECT ......
FROM ......
) AS ......
ON .....
LEFT OUTER JOIN ......
ON ......= ......
LEFT OUTER JOIN ......
ON .....AND ......
WHERE ......
哪位高手告诉我下上面的join和on 怎么跟 select 对应起来。看得我头晕!!!
(
SELECT DISTINCT
......
FROM ...... GROUP ......
) AS E2
ON ..... = .....
为一段
SELECT DISTINCT * FROM /*主表*/
INNER JOIN ( SELECT DISTINCT ......FROM ...... GROUP ......) AS E2
ON ..... = .....
INNER JOIN ( SELECT * FROM ......) AS ...
ON ......= ......AND ......
LEFT OUTER JOIN ( SELECT ...... FROM ......) AS ......
ON .....
LEFT OUTER JOIN ......
ON ......= ......
LEFT OUTER JOIN ......
ON .....AND ......
WHERE ......
--6个表的联合查询
......
FROM E1
......
INNER JOIN
(
SELECT DISTINCT
......
FROM ...... GROUP ......
)
AS E2
ON ..... = .....
INNER JOIN
( SELECT *
FROM ......
)
AS E3
ON ......= ......AND ......
LEFT OUTER JOIN
(
SELECT ......
FROM ......
)
AS E4
ON .....
LEFT OUTER JOIN
E5
ON ......= ......
LEFT OUTER JOIN ......
E6
ON .....AND ......
WHERE ......
E1 E2 E3 E4 E5 E6 就是相关连的表或子查询
INNER JOIN
(
SELECT DISTINCT
......
FROM ...... GROUP ......
) AS E2
ON ..... = ..... 那下面的INNER是怎么来的啊?