Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
select t1.quan as Qty, case when t1.prodtype in (0,1, 101) then t3.descript when t1.prodtype = 100 then t2.descript else 'no desc avail' end as Description, t1.costeach as 'Cost Each', (t1.quan * t1.costeach) as 'Extended Cost' from dba.posdetail as t1 left join dba.promo as t2 on t1.prodnum = t2.promonum left join dba.product as t3 on t1.prodnum = t3.prodnum where t1.transact = 899330
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!