SQL Update with a subquery 1

[jchewsmith]

I am trying to update a field in my table from a view based on a MAX(Date)

Table: dbrderLine
Fields LineNo, OrderNo, and ShipDate (there will be multiple row with the same OrderNo and each row needs to update based on the link to the OrderNo in dbo.MaxDate

View: dbo.MaxDate
Fields OrderNo and ShipDate

I need to update all shipdate fields in the OrderLine table where the OrderNo = the OrderNo in MaxDate

 

[hilfy]

Crystal is not really designed to allow you to update data. However, you might be able to accomplish this by using a stored procedure to get the data from the view after updating the field.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com