Trouble With Combining Three Selects

Ok, here's the deal. At the moment I have problems with extracting some data as the table structures refer to itself. To get the data I want I have three sql-queries setup as views. the first one takes the raw data out of the table:

fsp_marken:


Code Snippet
SELECT TOP (100) PERCENT
LFDNR,
KRITERIUM,
EINORDNUNG,
CASE kriterium WHEN 1 THEN 'Marken' ELSE CASE kriterium WHEN 2 THEN 'Markenhauptgruppe' ELSE CASE kriterium WHEN 3 THEN 'Markenuntergruppe' END END END AS Gruppierung

FROM dbo.ARTEINORDNUNG

WHERE (KRITERIUM = 1) AND (LFDNR <> 0) OR
(KRITERIUM = 2) AND (LFDNR <> 0) OR
(KRITERIUM = 3) AND (LFDNR <> 0)

ORDER BY KRITERIUM





The second one takes the necessary information from the first statement fsp_marken and fills up additional info in this case the article number:

fsp_marken2:



Code Snippet
SELECT
dbo.ARTIKEL.ARTNR1,
CASE fsp_marken.kriterium WHEN 1 THEN fsp_marken.einordnung END AS Marken,
CASE fsp_marken.kriterium WHEN 2 THEN fsp_marken.einordnung END AS Markenhauptgruppe, CASE fsp_marken.kriterium WHEN 3 THEN fsp_marken.einordnung END AS Markenuntergruppe


FROM dbo.ARTIKEL INNER JOIN
dbo.AEINORD ON dbo.ARTIKEL.LFDNR = dbo.AEINORD.ARTNR INNER JOIN
dbo.FSP_MARKEN ON dbo.AEINORD.KRITERIUM = dbo.FSP_MARKEN.KRITERIUM AND
dbo.AEINORD.EINORDNUNG = dbo.FSP_MARKEN.LFDNR


GROUP BY dbo.ARTIKEL.ARTNR1, dbo.FSP_MARKEN.KRITERIUM, dbo.FSP_MARKEN.EINORDNUNG





The third one takes the results from fsp_marken2 and groups them by artnr, getting only one resultset per article number:

fsp_marken3:


Code Snippet
SELECT
ARTNR1,
MAX(ISNULL(Marken, CHAR(NULL))) AS Marken,
MAX(ISNULL(Markenuntergruppe, CHAR(NULL))) AS Markenuntergruppe, MAX(ISNULL(Markenhauptgruppe, CHAR(NULL))) AS Markenhauptgruppe

FROM dbo.FSP_MARKEN2

GROUP BY ARTNR1







What I need is doing all the stuff in just one sql-statement relating on ARTIKEL.ARTNR1 as primary. I don't know If this can be accomplished...