I'll preface this by saying I'm pretty new in regards to SQL. I've looked for info on doing this, but haven't had much luck because I'm not exactly sure what I'm looking for or if it's even possible.

I'm trying to run a query against an order database. Within each record, I have a unit price and a qty. I was trying to run a query that would spit out a line item extended value by order. Such as....

select order_number Order, (unit_price * qty) Value
from order_line;

Outputting...

Order Value
===============
JRD76 $24.40
STY32 $78.27
etc
etc

I know the above syntax isn't "real", but I figured I should be able to do something along these lines, and just can't find the right way. Is it possible?

Thanks,
jdk

It seems like you were missing the "As" word, providing all the data you need is in the same table (orders).

select order_id As "order", (qty * unit_price) As "Value"
from sample;

Can you pls be more clear with your requirement

I use Oracle so I can only speak to their flavor.

What you have is almost there. Part of your problem is that both 'Order' and 'Value' are key words (to Oracle). If you write:

select order_number "Order", (unit_price * qty) "Value"
from order_line;

You should be home ( by that I mean "it should work"). You could even drop the () if you like. Tell me if this works.

Todd