Your question fails into same category as "Can I SELECT ... FROM * ; ?" It is not that easy to explain why, but you should never ask such questions.
Umm...That sounds a little harsh and totalitarianist. Did you actually mean that people shouldn't ask those kinds of questions? Or did you mean that this is not the proper list for such questions? I think that the latter is reasonable, since it is a general SQL syntax question and should be directed at a general SQL list. Your example question is more obviously incorrect SQL, though not necessarily obviously so to inexperienced users, but Seth's original question looks much more reasonable. In fact it could be quite useful for things like re-populating a table or in an INSERT...SELECT statement and perhaps it should be asked on a SQL list. I certainly would find it disconcerting and potentially horrifying if a list dedicated to improving a SQL code base told its subscribers not to ask prodding questions. I hope that was not the intent of your answer.
cheers.
michael
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
