---
title: "Unknown column node.RelId in 'on clause'"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/164455-unknown-column-node-relid-in-on-clause"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Travoni"
published: "2007-09-12T16:23:37.000Z"
updated: "2007-09-12T16:27:53.000Z"
replies: 1
views: 404
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/164455-unknown-column-node-relid-in-on-clause"
---

# Unknown column node.RelId in 'on clause'

## #1 — Travoni, 2007-09-12T16:23Z

SP:n 

```
PROCEDURE `procUseTemp`(sIds varchar(1000))
BEGIN 
DECLARE FirstPos INT;
DECLARE FirstPos1 INT;
DECLARE SecondPos INT; 
SET FirstPos=1;
	IF (LENGTH(sIds) > 0) THEN
        DROP TABLE IF EXISTS TempTable;
        CREATE TEMPORARY TABLE TempTable(id int) ENGINE=MEMORY;
		SET SecondPos = LOCATE(',',sIds,FirstPos);
		WHILE (SecondPos>0) DO
			INSERT INTO TempTable
			VALUES(cast(substring(sIds, FirstPos, (SecondPos - FirstPos)) as unsigned INT));
			set FirstPos=SecondPos+1;
			SET SecondPos=LOCATE(',',sIds,FirstPos);
		END WHILE;
		INSERT INTO TempTable
		VALUES(cast(right(sIds, LENGTH(sIds) - FirstPos + 1 ) as unsigned INT));
	END IF;
END;
```

Om jag kör denna så får jag felet: Unknown column node.RelId in 'on clause'

```
CALL procUseTemp('6');

SELECT distinct(node.id)
FROM categories AS node,categories AS parent
INNER JOIN temptable AS tmp 
ON tmp.ID = node.RelId
WHERE node.lft BETWEEN parent.lft AND parent.rgt
```

Denna fullar men ger fel resultat:

```
CALL procUseTemp('6');

SELECT distinct(node.id),node.RelId
FROM categories AS node
INNER JOIN categories AS parent
ON node.lft BETWEEN parent.lft AND parent.rgt
INNER JOIN temptable AS tmp 
ON tmp.ID = node.RelId
```

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

## #2 — Travoni, 2007-09-12T16:27Z

```
CALL procUseTemp('6');
SELECT distinct(node.id)
FROM categories AS node
INNER JOIN categories AS parent
ON node.lft BETWEEN parent.lft AND parent.rgt
INNER JOIN temptable AS tmp 
ON tmp.ID = [B]parent.Id[/B]
```

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/164455-unknown-column-node-relid-in-on-clause