| Author |
 Topic  |
|
|
joemama
Posting Yak Master
113 Posts |
 Posted - 05/16/2005 : 15:43:57
|
the query below i have that works fine...
but now i want to have
dbo.ProdOrderDetails.DetailQuantity * dbo.ProdOrderDetails.DetailProdPrice = a new column called ItemTotal
can someone tell me how to do it?
CREATE VIEW dbo.QryCartDetails
AS
SELECT dbo.ProdOrderDetails.DetailGUID, dbo.ProdOrderDetails.DetailQuantity, dbo.ProdOrderDetails.DetailOrderID, dbo.Products.ProdName,
dbo.Products.ProdShortDesc, dbo.Products.ProdLongDesc, dbo.Products.ProdID, dbo.ProdOrderDetails.DetailID, dbo.ProdScent.ProdScentLabel, dbo.ProdSize.ProdSizeLabel, dbo.ProdSize.ProdWeight, dbo.ProdOrderDetails.DetailProdPrice
FROM dbo.Products INNER JOIN
dbo.ProdOrderDetails ON dbo.Products.ProdID = dbo.ProdOrderDetails.DetailProdID LEFT OUTER JOIN
dbo.ProdSize ON dbo.ProdOrderDetails.DetailSize = dbo.ProdSize.ProdSizeID LEFT OUTER JOIN
dbo.ProdScent ON dbo.ProdOrderDetails.DetailScent = dbo.ProdScent.ProdScentID
|
|
|
JimL
SQL Slinging Yak Ranger
USA
1530 Posts |
Posted - 05/16/2005 : 15:49:26
|
CREATE VIEW dbo.QryCartDetails
AS
SELECT dbo.ProdOrderDetails.DetailGUID, dbo.ProdOrderDetails.DetailQuantity, dbo.ProdOrderDetails.DetailOrderID, dbo.Products.ProdName,
dbo.Products.ProdShortDesc, dbo.Products.ProdLongDesc, dbo.Products.ProdID, dbo.ProdOrderDetails.DetailID, dbo.ProdScent.ProdScentLabel, dbo.ProdSize.ProdSizeLabel, dbo.ProdSize.ProdWeight, dbo.ProdOrderDetails.DetailProdPrice,
dbo.ProdOrderDetails.DetailQuantity * dbo.ProdOrderDetails.DetailProdPrice As ItemTotal
FROM dbo.Products INNER JOIN
dbo.ProdOrderDetails ON dbo.Products.ProdID = dbo.ProdOrderDetails.DetailProdID LEFT OUTER JOIN
dbo.ProdSize ON dbo.ProdOrderDetails.DetailSize = dbo.ProdSize.ProdSizeID LEFT OUTER JOIN
dbo.ProdScent ON dbo.ProdOrderDetails.DetailScent = dbo.ProdScent.ProdScentID
Jim
Users <> Logic |
Edited by - JimL on 05/16/2005 15:50:16 |
 |
|
| |
Topic |
|
|
|
calculation in a query
Forum Locked
