View Single Post
  #4 (permalink)  
Old 2006-07-24, 06:38 AM
vladimir_cz vladimir_cz is offline
Senior Member
 
Join Date: Jul 2006
Location: Prague, Czech Republic
Posts: 193
vladimir_cz is on a distinguished road
Send a message via ICQ to vladimir_cz Send a message via MSN to vladimir_cz Send a message via Yahoo to vladimir_cz Send a message via Skype™ to vladimir_cz
Default

just add one calulated column with next way:
select peso, peso*1.2 as peso_with_tax from <table>

or just sum?
select sum(peso) from table where...
if need, add group by for calculate sums for each date, some code, etc.
__________________
Thank you. Vladimir, Czech Republic.
http://www.smartwebco.com/
I'm looking for job.
Reply With Quote