Skip to main content

Aliases and selecting from a select

Rarely do you need select from a select statement.

Occasionally this pops up with complex PIVOTs and UNPIVOTs.

The tip when doing this is (in MSSQL) is the "table" select statement needs to be aliased.

For example, the following statement will not work:

SELECT * FROM ( SELECT * FROM blah ) 

However, the following statement will work:

SELECT * FROM ( SELECT * FROM blah ) x



Comments

Post a Comment

Popular posts from this blog

Javascript Form Validation

It's real simple. All you need to do is call a javascript function in a html  " onsubmit " in the form tag as a javascript return, like this       <form method="post" action="dosomething.php" onsubmit="return validateForm();"> If the code completes ok, the form is then sent to the page listed in "action" http://www.w3schools.com/js/js_form_validation.asp If the function specified in the onsubmit returns false, then the form is not sent to the page mentioned in action.
Post a Comment
Read more