Problem mit SQL-Statement

[SeRi]

Hallo,

habe jetzt eine Hintertür-Lösung gefunden, aber ich hätte gerne die "feine englische Art". Will sagen: Kann man diese beiden durch "UNION" verbundenen SELECTS auch in einem zusammenfassen?:

(SELECT
    Level1.Id AS MainId,
    Level1.Name AS MainCategory,
    Level2.Id AS SubId,
    Level2.Name AS SubCategory,
    Portfolio.Id,
    Portfolio.Name,
    Portfolio.Filename,
    Portfolio.Width,
    Portfolio.Height
FROM
    define_portfolio_categories AS Level1
JOIN
    define_portfolio_categories AS Level2
ON
    Level2.ParentId = Level1.Id
LEFT JOIN
    agent_portfolio_2_categories AS Portfolio2Categories
ON
    Portfolio2Categories.CategoryId = Level2.Id
LEFT JOIN
    data_portfolio AS Portfolio
ON
    Portfolio2Categories.PortfolioId = Portfolio.Id)
UNION (SELECT
    Level1.Id AS MainId,
    Level1.Name AS MainCategory,
    Level1.ParentId AS SubId,
    Level1.ParentId AS SubCategory,
    Portfolio.Id,
    Portfolio.Name,
    Portfolio.Filename,
    Portfolio.Width,
    Portfolio.Height
FROM
    define_portfolio_categories AS Level1
LEFT JOIN
    agent_portfolio_2_categories AS Portfolio2Categories
ON
    Portfolio2Categories.CategoryId = Level1.Id
LEFT JOIN
    data_portfolio AS Portfolio
ON
    Portfolio2Categories.PortfolioId = Portfolio.Id
WHERE
    Level1.ParentId IS NULL
ORDER BY
    Level1.Order,
    Level2.Order,
    Portfolio.Name)

Danke.