MySQL Forums
Forum List  »  French

Problème count avec subquery
Posted by: Dominique van der Wal
Date: February 11, 2007 08:19AM

Bonjour,

j'ai une erreur avec un count (version 3.23.58) ...

Voici mon code sql (version courte et version normale d'un query)...

Des idées pour résoudre mon problème ?
Merci d'avance
Dominique

version courte
-------------

SELECT COUNT( * )
FROM (
SELECT KeyContent
FROM t_content_main
) AS DER

#1064 - You have an error in your SQL syntax near 'SELECT KeyContent FROM t_content_main) AS DER' at line 1


Version normale
----------------
SELECT COUNT(*) FROM (SELECT DISTINCT KeyContent FROM t_content_main LEFT JOIN t_content_version ON t_content_main.KeyContent = t_content_version.KeyMaster WHERE t_content_main.FullKeyMaster LIKE '%' ) AS DER

#1064 - You have an error in your SQL syntax near 'SELECT DISTINCT KeyContent FROM t_content_main LEFT JOIN t_content_version ON t_' at line 1

Options: ReplyQuote


Subject
Views
Written By
Posted
Problème count avec subquery
4454
February 11, 2007 08:19AM
2930
February 11, 2007 09:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.