---
title: "SQL-problem"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/107232-sql-problem"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "lillebror"
published: "2004-07-13T10:12:18.000Z"
updated: "2004-07-13T10:56:05.000Z"
replies: 2
views: 263
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/107232-sql-problem"
---

# SQL-problem

## #1 — lillebror, 2004-07-13T10:12Z

Får följande felkod i min SQL-sats...

Microsoft JET Database Engine error '80040e14' 
Syntax error in FROM clause. 
/forumdisplay.asp, line 32 

```
"SELECT iif(maxDate is null,ThreadPosted,maxDate), author,subject from ((SELECT (select max(ThreadPosted from t_threads where answerid = t.threadid) as maxDate, ThreadPosted, author, subject from t_threads t) dt order by 1 desc"
```

Någon idé om vad som är fel?

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

## #2 — toha, 2004-07-13T10:36Z

Chansar på det här:

```
SELECT 
	iif(maxDate is null,ThreadPosted,maxDate) AS col1,
	author,
	subject 
FROM
	(
		SELECT 
			(
				select 
					max(ThreadPosted)
				from 
					t_threads 
				where 
					answerid = t.threadid
			) as maxDate,
			ThreadPosted, 
			author, 
			subject 
		from 
			t_threads t
	) dt
order by 
	col1 desc
```

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

## #3 — lillebror, 2004-07-13T10:56Z

Får upp föjande felkod nu när jag kör SQL-satsen...

Microsoft JET Database Engine error '80040e10' 

No value given for one or more required parameters. 

/forumdisplay.asp, line 35

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/107232-sql-problem