On 21 January 2011 11:58, Karl DeSaulniers k...@designdrumm.com wrote:
I did not know you could do a SELECT inside a SELECT.
Commonly known as a sub select.
You can use them like ...
SELECT columns
FROM ( SELECT columns FROM table)
WHERE column IN (SELECT column FROM table)
As part of a FROM
Ahh yes, I remember that now.
Thank you.
Karl
On Jan 21, 2011, at 6:17 AM, Richard Quadling wrote:
On 21 January 2011 11:58, Karl DeSaulniers k...@designdrumm.com
wrote:
So to do descending order I'd put DES or DEC? Just curious about
that one.
ASC and DESC
--
Richard Quadling
Twitter
Very informative,
Thank you Richard.
I will have to flag this one and come back to it.
My database structure may require something of this measure down the
line
with the auditing ability I plan on building into the admin section.
Never heard of USE AdventureWorks. Is that a SQL system
On 21 January 2011 12:39, Karl DeSaulniers k...@designdrumm.com wrote:
Very informative,
Thank you Richard.
I will have to flag this one and come back to it.
My database structure may require something of this measure down the line
with the auditing ability I plan on building into the admin