, 30 2017 . 15:32
+
, .
, LEFT JOIN. , , , Null... ! , ...
.
| + SubQuery1 |
SELECT . & ' - ' & . AS 1, .
FROM
INNER JOIN ON . = .
|
| + SubQuery2 |
SELECT .1, . & ' - ' & . AS 2
FROM
INNER JOIN (
INNER JOIN ON . = .2
) ON . = .
|
, :
| + -1 |
SELECT SubQuery1.1 AS 1, SubQuery2.2 AS 2, SubQuery1. AS 1, SubQuery2.1 AS 2
FROM SubQuery1
LEFT JOIN SubQuery2 ON SubQuery1. = SubQuery2.1;
|
, :
| + -2 |
SELECT SubQuery1.1 AS 1, SubQuery2.2 AS 2, SubQuery1. AS 1, SubQuery2.1 AS 2
FROM (
SELECT . & ' - ' & . AS 1, .
FROM
INNER JOIN ON . = .
) AS SubQuery1
LEFT JOIN (
SELECT .1, . & ' - ' & . AS 2
FROM
INNER JOIN (
INNER JOIN ON . = .2
) ON . = .
) AS SubQuery2 ON SubQuery1. = SubQuery2.1;
|
, , , SubQuery2.2 AS 2 SubQuery2.1 AS 2 Null... SubQuery2.1 AS 2 Null ... SubQuery2.2 AS 2 " - ".
("-2" - , ).
???
http://www.sql.ru/forum/1261598/strannyy-vyvod-zaprosa
