Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
joemama
Posting Yak Master
113 Posts |
Posted - 2005-05-16 : 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 ItemTotalcan someone tell me how to do it?CREATE VIEW dbo.QryCartDetailsASSELECT 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.DetailProdPriceFROM dbo.Products INNER JOINdbo.ProdOrderDetails ON dbo.Products.ProdID = dbo.ProdOrderDetails.DetailProdID LEFT OUTER JOINdbo.ProdSize ON dbo.ProdOrderDetails.DetailSize = dbo.ProdSize.ProdSizeID LEFT OUTER JOINdbo.ProdScent ON dbo.ProdOrderDetails.DetailScent = dbo.ProdScent.ProdScentID |
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-05-16 : 15:49:26
|
CREATE VIEW dbo.QryCartDetailsASSELECT 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 ItemTotalFROM dbo.Products INNER JOINdbo.ProdOrderDetails ON dbo.Products.ProdID = dbo.ProdOrderDetails.DetailProdID LEFT OUTER JOINdbo.ProdSize ON dbo.ProdOrderDetails.DetailSize = dbo.ProdSize.ProdSizeID LEFT OUTER JOINdbo.ProdScent ON dbo.ProdOrderDetails.DetailScent = dbo.ProdScent.ProdScentIDJimUsers <> Logic |
|
|
|
|
|
|
|