How can I use a subquery as alias in SQL Server 2005

Posted by Soham Dasgupta on Stack Overflow See other posts from Stack Overflow or by Soham Dasgupta
Published on 2010-03-19T11:10:57Z Indexed on 2010/03/19 11:21 UTC
Read the original article Hit count: 280

select 
b.bill_no as 'Bill Number',
(select descript from SALE_TERMS where STERMS_CODE='99')=b.[99]
from BILLDET as b

© Stack Overflow or respective owner