gistfile1.sql

SELECT art.a_nr, art.a_type, data.via
FROM dbo.art
LEFT JOIN (
	SELECT a_nr, SUM(res_kvant - res_rappkv) AS via
	FROM dbo.reserv
	GROUP BY a_nr
) AS data ON art.a_nr = data.a_nr


SELECT
	art.a_nr, art.a_type, data.via,
	(SELECT COUNT(*) FROM dbo.arttxt WHERE a_nr = art.a_nr) AS txt,
	(
		SELECT at_tekst
		FROM dbo.arttxt
		WHERE a_nr = art.a_nr AND spr_kode = 'NOK' AND kk_kode = 98
	) AS v
FROM dbo.art
LEFT JOIN (
	SELECT a_nr, SUM(res_kvant - res_rappkv) AS via
	FROM dbo.reserv
	GROUP BY a_nr
) AS data ON art.a_nr = data.a_nr