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 |
|
maifs
Yak Posting Veteran
57 Posts |
 Posted - 2010-01-03 : 06:50:44
|
| plz convert it into update and delete queries/SELECT dbo.Sales.Reciept_Number, dbo.Sales.Sale_Date, dbo.SaleDetails.product_Quantity, dbo.Products.product_Name, dbo.SalesPersons.s_empName, dbo.Managers.manager_Name, dbo.Customers.c_Full_Name, dbo.Categories.Name FROM dbo.Sales INNER JOIN dbo.SalesPersons ON dbo.Sales.SalesPersonID = dbo.SalesPersons.s_empCode INNER JOIN dbo.SaleDetails ON dbo.Sales.Reciept_Number = dbo.SaleDetails.Reciept_Number INNER JOIN dbo.Products ON dbo.SaleDetails.product_ID = dbo.Products.product_ID INNER JOIN dbo.Managers ON dbo.Sales.ManagerID = dbo.Managers.ID INNER JOIN dbo.Customers ON dbo.Sales.CustomerID = dbo.Customers.customer_ID INNER JOIN dbo.Categories ON dbo.Products.product_Category_ID = dbo.Categories.ID |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2010-01-03 : 06:54:04
|
| from which table u want to delete the recordsand which fields to be updated in which table........... |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-03 : 11:28:02
|
| please provide some sample data and explain what you need to update/delete |
|
|
|
|
|
|
update and delete join query problem