SELECT count(*) FROM (SELECT col1, col2 FROM table)
OK, so that's what you call an "inline view" is it?
Yep :-)
What then is a derived table, or is a derived table just a synonym for inline view?
I'm not sure what the "official" name for this is. I have heard both. So from my point of view a derived table and an inline view are the same.
What's wrong with SELECT COUNT(col1) FROM table?Nothing. But my statement was just an example to show the syntax.
But sometimes when things get more complicated it *is* very handy, and I have used it now and then, and wouldn't want to miss it :-)
Thomas
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
