I have two tables, Discrepancies and Actions that are linked by a field called JobNumber
What I need to do in a stored procedure is return a date field from the last record entered in the Actions table where the JobNumber is the same
The Actions tables primary key is an Identity field.
I'm trying to make a subquery but am stuck on the syntax.
Any help would be appreciated, this is just a bit beyond my skill set. Thanks.
View Complete Post