Does anyone know how I can select the max date, based on a foreign key in a 2nd table, and update the date field in the first table with that value?
Here's what I have now
1st Table Fields (One record per Stock_No)
Stock_NO
Last_Update
2nd table (Multiple Records per Stock_NO)
Stock_No
Update_Date
I basically want to grab the most recent Update_Date per Stock_No, and update the 1st table with that value.
Can anyone offer any ideas? I've never done an update like this. Thanks
Here's what I have now
1st Table Fields (One record per Stock_No)
Stock_NO
Last_Update
2nd table (Multiple Records per Stock_NO)
Stock_No
Update_Date
I basically want to grab the most recent Update_Date per Stock_No, and update the 1st table with that value.
Can anyone offer any ideas? I've never done an update like this. Thanks