SELECT COUNT(p.artID) AS LCNT FROM pages p WHERE p.siteID = 1
-Original Message-
From: Nick Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 8:20 AM
To: [EMAIL PROTECTED]
Subject: Quick SQL querie on count and embedded SELECT
Hi all,
I want to do this,
SELECT
Hi all,
I want to do this,
SELECT COUNT (a.artID) AS LCNT FROM (SELECT DISTINCT a.artID FROM pages p
WHERE p.siteID = 1)
Any ideas how to make this MySQL friendly?
Cheers,
Nick
_
Chat with friends online, try MSN Messenger: h
