Пробвай с UNION така някак

       SELECT s.d_nomer

              , (SELECT d_name FROM sklad WHERE d_nomer = s.d_nomer) AS d_name

              , SUM(col) AS col

              , SUM(scol) AS scol

       FROM   (

              SELECT nom_nomer_full AS d_nomer

                     , col

                     , 0 AS scol

              FROM   eksbel



              UNION ALL



              SELECT snomer_full

                     , 0

                     , scol

              FROM   sklraz

              ) s

       GROUP BY s.d_nomer

Съдържаниет е скрито
Влезте за да го видите