SQL command for minus 2 columns

From: OneZerO <onezero_at_post1.com>
Date: Tue, 11 May 1999 11:33:11 +1000
Message-ID: <373787ad_at_news.ausmail.com>

Hi all,

Thanks for taking time read my posting... i'm a new beginner in Database, currently i'm doing a assignment on using Oracle Development 2000. I run [Quoted] into a problem, where i need to minus ship_qty from order_qty which both are link by a product_no.

how can i do the above problem using SELECT statement? do i need to create a column in my database to hold the value return back to me after the minus operation? btw, i need to insert this SELECT statement into my Report Builder (i'm using Developer 2000 version 2)

if u could be kindly help me to solve this problem, please email to me at onezero_at_post1.com Thanks for your kind help, i really appreaciate them very much!

Cheers
Evelyn

---

Life is not about what you've gained,
But what you've done..

---

Received on Tue May 11 1999 - 03:33:11 CEST