SQL Server CE, Subselects - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

SQL Server CE, Subselects

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-10-08 : 09:50:49

Jon Petter writes "I have a query where I want to fint the topics which have only one keyword.

SELECT TOPI.SORT_ORDER, TOPI.CODE, TOPI.CAPTION FROM TOPICS AS TOPI WHERE 1 = (SELECT COUNT(*) FROM TOPIC_KEYWORDS AS TOKE)

This gives the following error:
Error: 0x80040e14DB_E_ERRORSINCOMMAND
Minor Error: 25501
Description: The command contained one or more errors

Is this not supported in CE?
I use 1.1, migth a newer version correct this?

Regards,
Jon Petter Hjulstad"

1fred
Posting Yak Master

158 Posts

Posted - 2002-10-08 : 11:27:06

Try to remove the "as" near your table. Like this, maybe it will work.

SELECT TOPI.SORT_ORDER, TOPI.CODE, TOPI.CAPTION FROM TOPICS TOPI WHERE 1 = (SELECT COUNT(*) FROM TOPIC_KEYWORDS TOKE)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources