newbe how to add a column

[Michael Lewandowski]

I need to know how to add a column of numbers and get a total using my sql
command.

SELECT v.vid, title, purchdate, sum(cost) AS Total
FROM Video v, Vidcopy vc
WHERE vid.v = vid.vc

I need to know how to add the cost column and get a total .

Thanks for any and all help

[D. Pickering]

I'm not sure what you have and want.
To add a cost field to a table do "alter table Video cost float(10,2)".
Note that once you add sum(cost) to the query, you get one line back sum of
all costs...unless you add some grouping clause.
Tell us your schema of the 2 tables and what you mean by "sum" like per
video or entire table, and we'll have more to go on.
dp

"Michael Lewandowski" <mi*******@charter.net> wrote in message
news:vn************@corp.supernews.com...

I need to know how to add a column of numbers and get a total using my sql
command.

SELECT v.vid, title, purchdate, sum(cost) AS Total
FROM Video v, Vidcopy vc
WHERE vid.v = vid.vc

I need to know how to add the cost column and get a total .

Thanks for any and all help

[D. Pickering]

I'm not sure what you have and want.
To add a cost field to a table do "alter table Video cost float(10,2)".
Note that once you add sum(cost) to the query, you get one line back sum of
all costs...unless you add some grouping clause.
Tell us your schema of the 2 tables and what you mean by "sum" like per
video or entire table, and we'll have more to go on.
dp

"Michael Lewandowski" <mi*******@charter.net> wrote in message
news:vn************@corp.supernews.com...

I need to know how to add a column of numbers and get a total using my sql
command.

SELECT v.vid, title, purchdate, sum(cost) AS Total
FROM Video v, Vidcopy vc
WHERE vid.v = vid.vc

I need to know how to add the cost column and get a total .

Thanks for any and all help

[D. Pickering]

correct alter syntax (adding the word "add") "alter table Video add cost
float(10,2)".
"D. Pickering" <dc*****@hps.com> wrote in message
news:Hd*********************@newssvr30.news.prodig y.com...

I'm not sure what you have and want.
To add a cost field to a table do "alter table Video cost float(10,2)".
Note that once you add sum(cost) to the query, you get one line back sum of all costs...unless you add some grouping clause.
Tell us your schema of the 2 tables and what you mean by "sum" like per
video or entire table, and we'll have more to go on.
dp

"Michael Lewandowski" <mi*******@charter.net> wrote in message
news:vn************@corp.supernews.com...

I need to know how to add a column of numbers and get a total using my sql command.

SELECT v.vid, title, purchdate, sum(cost) AS Total
FROM Video v, Vidcopy vc
WHERE vid.v = vid.vc

I need to know how to add the cost column and get a total .

Thanks for any and all help

[D. Pickering]

correct alter syntax (adding the word "add") "alter table Video add cost
float(10,2)".
"D. Pickering" <dc*****@hps.com> wrote in message
news:Hd*********************@newssvr30.news.prodig y.com...

I'm not sure what you have and want.
To add a cost field to a table do "alter table Video cost float(10,2)".
Note that once you add sum(cost) to the query, you get one line back sum of all costs...unless you add some grouping clause.
Tell us your schema of the 2 tables and what you mean by "sum" like per
video or entire table, and we'll have more to go on.
dp

"Michael Lewandowski" <mi*******@charter.net> wrote in message
news:vn************@corp.supernews.com...

I need to know how to add a column of numbers and get a total using my sql command.

SELECT v.vid, title, purchdate, sum(cost) AS Total
FROM Video v, Vidcopy vc
WHERE vid.v = vid.vc

I need to know how to add the cost column and get a total .

Thanks for any and all help