On Wednesday, August 28, 2002, at 06:06 , Tuomo Lesonen wrote: > This doesn't work: SELECT COUNT(*), id, name FROM names WHERE id = 1; > > I'm using MS SQL2000. The query above is probably not well > formed SQL, or > SQL2000 doesn't know what to do with it... :(
The count(*) syntax works in MySQL, but the documentation for the latter indicates that it's not standard SQL. (It's sooo convenient, though...:-)) A. --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>