Multiply two field

[mjawadkhatri]

How to multiply two field value ?? Like i Have a table prod........dept..qty..rate..date mouse.......abc...10...20....5/1/2010 monitor.....xyz...5....10....5/2/2010 mouse.......abc...12...20....5/3/2010 monitor.....xyz...15...10....5/4/2010 Keyboard....abc...20....8....5/5/2010 now i want to show my record like Dept.........(QTY*Rate) abc...........600 xyz...........200 Thanks In Advance Jawad Khatri

[Luc Pattyn]

try this:

SELECT qty * rate AS product FROM table WHERE ...

It is in the documentation[^]! :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

[mjawadkhatri]

Thanks Sir

[Luc Pattyn]

you're welcome. :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.