Posted by Erich93063 on 01/11/06 20:13

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!!

• Next in forum: show stored procedure
• Prev in forum: SqlCE Synchronization Issue: Native Error 29006, The process could not deliver the snapshot to the Subscriber
• Thread view: Simple SQL query question

[Reply to this message]