Eso que le cuesta :), aqui un aproach del query, te dije que le faltaban condiciones ;)
Código SQL:
Ver originalCREATE TABLE Entradas(idTienda CHAR(2),Codigo CHAR(12),Fecha smalldatetime,idAlmacen CHAR(2),Cantidad money)
CREATE TABLE Salidas(idTienda CHAR(2),Codigo CHAR(12),Fecha smalldatetime,idAlmacen CHAR(2),Cantidad money)
CREATE TABLE datEmp (idTienda CHAR(2),nickname nvarchar(20))
INSERT INTO Entradas VALUES ('08','004-113',GETDATE(),'04',325.34)
INSERT INTO Entradas VALUES ('01','004-113',GETDATE(),'01',400.4)
INSERT INTO Entradas VALUES ('01','004-113',GETDATE(),'01',1200.77)
INSERT INTO Entradas VALUES ('08','004-113',GETDATE(),'01',325)
INSERT INTO Entradas VALUES ('08','004-113',GETDATE(),'04',238.01)
INSERT INTO datEmp VALUES ('08','tienda8')
INSERT INTO datEmp VALUES ('01','tienda1')
INSERT INTO datEmp VALUES ('02','tienda2')
INSERT INTO datEmp VALUES ('09','tienda9')
INSERT INTO datEmp VALUES ('07','tienda7')
INSERT INTO Salidas VALUES ('08','004-113',GETDATE(),'04',25.04)
INSERT INTO Salidas VALUES ('01','004-113',GETDATE(),'01',10.50)
INSERT INTO Salidas VALUES ('02','004-113',GETDATE(),'01',600.17)
INSERT INTO Salidas VALUES ('09','004-113',GETDATE(),'01',35.04)
INSERT INTO Salidas VALUES ('08','004-113',GETDATE(),'04',33.01)
SELECT * FROM(
SELECT t1.codigo,t2.nickname,SUM(cantidad) AS entradas
--*
FROM Entradas AS t1
LEFT JOIN datEmp AS t2 ON (t1.idtienda=t2.idTienda)
--where t1.codigo between '004-113' AND '004-113' and t1.fecha BETWEEN '2014-05-03' AND '2014-08-21'
GROUP BY t1.codigo,t2.nickname
) AS t1 RIGHT JOIN
(
SELECT t1.codigo,t2.nickname,SUM(cantidad) AS salidas FROM salidas AS t1
LEFT JOIN datEmp AS t2 ON (t1.idtienda=t2.idTienda)
--where t1.codigo between '004-113' AND '004-113' and t1.fecha BETWEEN '2014-05-03' AND '2014-08-21'
GROUP BY t1.codigo,t2.nickname) AS t2 ON (t1.codigo=t2.codigo AND t1.nickname=t2.nickname)