Simple SQL query question

[Erich93063]

I am trying to query a table of items There is a field for the name of
the item, price, quantity etc. When I query I would like to return a
"total price" which would be price * quantity and alias it out as
"Total". So something along the lines of:

SELECT vchrItem,
monPrice,
intQuanity,
(monPrice * intQuantity) AS Total,
...
FROM ...
WHERE intTableID = 12345

Obviously thats NOT how you do it but that is what I am trying to do. I
NEED this to come out in the query as I cannot calculate this
afterwards. The total value needs to be part of the recordset.

THANKS!!

[Hugo Kornelis]

On 11 Jan 2006 10:13:11 -0800, Erich93063 wrote:

I am trying to query a table of items There is a field for the name of
the item, price, quantity etc. When I query I would like to return a
"total price" which would be price * quantity and alias it out as
"Total". So something along the lines of:

SELECT vchrItem,
monPrice,
intQuanity,
(monPrice * intQuantity) AS Total,
...
FROM ...
WHERE intTableID = 12345

Obviously thats NOT how you do it but that is what I am trying to do.

Hi Erich93063,

This is EXACTLY how you do it.

Did you run the code and get an error or incorrect results? If so,
please post more specific information (e.g. the text of the error
message) to help us troubleshoot. See www.aspfaq.com/5006 to find out
what information we need to help you.

--
Hugo Kornelis, SQL Server MVP

[Erich93063]

lol well I guess I should try things before I assume they dont work
huh? That DID work. DOH!! THANKS!