How can I use a subqyery 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:11 UTC
Read the original article Hit count: 214

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