-
-
Save anonymous/54300124b3c335f38a46 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment