Thread
:
very easy SQL question
View Single Post
02-10-2005, 02:06 PM
Nathan
Confirmed User
Industry Role:
Join Date: Jul 2003
Posts: 3,108
SELECT SUM(IF(status='Approved',1,0)) approved, SUM(IF(status='Pending',1,0)) pending FROM galleries;
__________________
"Think about it a little more and you'll agree with me, because you're smart and I'm right."
- Charlie Munger
Nathan
View Public Profile
Find More Posts by Nathan