Klurig typ av Union

SQL = " SELECT n.intID, n.strName, 'TRUE' [b], m.strName[/b]" _
& " FROM navigation n " _
& " WHERE EXISTS " _ 
& " (SELECT a.intID FROM access a, users u WHERE " _
& " u.intID = " & request("ID") & " AND  u.intID = a.intUserID AND " _
& " a.intNavigationID = n.intID ORDER BY n.intSortfield ) " _
& " UNION " _
& " SELECT n.intID, n.strName, 'FALSE' [b], m.strName[/b]" _
& " FROM navigation n " _
& " WHERE NOT EXISTS " _
& " (SELECT a.intID FROM access a, users u WHERE " _
& " u.intID = " & request("ID") & " AND u.intID = a.intUserID AND " _
& " a.intNavigationID = n.intID ORDER BY n.intSortfield );"

Jag vet inte om ni kan läsa denna koden, men för er som fattar... Koden i sig fungerar med undantaget för det feta.

Jag vill alltså ha in ytterligare ett namn:

navigationMeny m

m.intID = n.intMenyID

Hur skriver jag resten av koden!?

SQL = " SELECT n.intID, n.strName, 'TRUE' , m.strName" _
& " FROM navigation n inner join navigationMeny m " _
& " on m.intID = n.intMenyID " _
& " WHERE EXISTS " _ 
& " (SELECT a.intID FROM access a, users u WHERE " _
& " u.intID = " & request("ID") & " AND  u.intID = a.intUserID AND " _
& " a.intNavigationID = n.intID ORDER BY n.intSortfield ) " _
& " UNION " _
& " SELECT n.intID, n.strName, 'FALSE' , m.strName" _
& " FROM navigation n  inner join navigationMeny m " _
& " on m.intID = n.intMenyID " _
& " WHERE NOT EXISTS " _
& " (SELECT a.intID FROM access a, users u WHERE " _
& " u.intID = " & request("ID") & " AND u.intID = a.intUserID AND " _
& " a.intNavigationID = n.intID ORDER BY n.intSortfield )"