Looks from here like you missed the "times two" part of the SQL string. -m On Jan 15, 2006, at 7:45 PM, Jary Nubla wrote: >> why not try.. >> >> SELECT materialMaster.Rate, sum(materialMaster.'QTY') * 2 as TOT >> FROM materialMaster WHERE QTY>=10 > > "Zaid, Shaikh" <shaikh_zaid@xxxxxxxxx> wrote: How to execute a > sql query which sums up a field on a criteria and then doubles the > value. > > SELECT materialMaster.Rate, sum(materialMaster.'QTY') as TOT > FROM materialMaster WHERE QTY>=10 > > the above sql statement is working fine but i m not getting the > solution to double the value i mean i need twice of TOT. I cannot > store tot and then double the value i need it within the sql > statement as a field code. > > > Zaid > PHP Data object relational mapping generator http://www.metastorage.net/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-objects/ <*> To unsubscribe from this group, send an email to: php-objects-unsubscribe@xxxxxxxxxxxxxxx <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
