Home » Other » Training & Certification » URGENT: Calculation query
URGENT: Calculation query Sat, 03 May 2008 11:27
 himesh Messages: 5Registered: May 2008 Junior Member
Hi

I have left my coursework to the last minute and really need your help!

I have created multiple tables and have input data into them, now i have to query one table and perform a vat calculation on one field, the vat value has to be inputted into one of the fields and then the vat taken from the gross total to form the net total, does anybody have a clue how to do this?

this is my table structure

CREATE TABLE Client_orders
(Order_number SMALLINT,
Order_date DATE,
Order_time SMALLINT,
LTC_staff_number SMALLINT,
Client_staff_number SMALLINT,
Discounted_amount NUMERIC(7,2),
Net_order_total NUMERIC(7,2),
VAT NUMERIC(7,2),
Gross_order_total NUMERIC(7,2),
CONSTRAINT Co_pk PRIMARY KEY (Order_number));
Re: URGENT: Calculation query [message #317789 is a reply to message #317788] Sat, 03 May 2008 11:42
 BlackSwan Messages: 25428Registered: January 2009 Location: SoCal Senior Member
>URGENT: Calculation query

Please explain why it is URGENT for me to solve this problem for you.

gross-vat=net; basic primary school mathematics

http://www.orafaq.com/forum/t/88153/0/

[Updated on: Sat, 03 May 2008 11:44] by Moderator

Report message to a moderator

Re: URGENT: Calculation query [message #317790 is a reply to message #317789] Sat, 03 May 2008 11:47
 himesh Messages: 5Registered: May 2008 Junior Member
its urgent because as i stated in the topic, i have left it to the last minute.

is there not a special code? like select from.....
Re: URGENT: Calculation query [message #317791 is a reply to message #317790] Sat, 03 May 2008 11:50
 Michel Cadot Messages: 64846Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator
The only thing that is urgent is that you read and follow OraFAQ Forum Guide.

Regards
Michel
Re: URGENT: Calculation query [message #317792 is a reply to message #317788] Sat, 03 May 2008 11:51
 BlackSwan Messages: 25428Registered: January 2009 Location: SoCal Senior Member
>this is my table structure
This appears to be for MYSQL & not Oracle.

http://www.orafaq.com/forum/t/88153/0/
Re: URGENT: Calculation query [message #317797 is a reply to message #317788] Sat, 03 May 2008 13:26
 Barbara Boehmer Messages: 8709Registered: November 2002 Location: California, USA Senior Member
Since your table structure appears to be MySQL and not Oracle and this is an Oracle forum, not a MySQL forum, you should post your problem on a MySQL forum, like perhaps one of the following or any others that you might find searching the web using Google or whatever search tool you prefer:

http://pipetalk.quest-pipelines.com/default.asp?boardid=mysql

http://forums.mysql.com/
 Previous Topic: UPDATE sql statement help please Next Topic: Group by having
Goto Forum:

Current Time: Mon May 29 06:35:56 CDT 2017

Total time taken to generate the page: 0.10788 seconds