---
title: "Klurig typ av Union"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/84352-klurig-typ-av-union"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Eclipse"
published: "2003-08-16T12:01:00.000Z"
updated: "2003-08-16T17:39:37.000Z"
replies: 1
views: 181
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/84352-klurig-typ-av-union"
---

# Klurig typ av Union

## #1 — Eclipse, 2003-08-16T12:01Z

```
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!?

Permalänk: https://www.webforum.nu/p/84352

## #2 — LarsG, 2003-08-16T17:39Z

```
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 )"
```

Permalänk: https://www.webforum.nu/p/1139342

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/84352-klurig-typ-av-union