July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.