Hi,
Simply Need to update a table where revision field is the maxiumum in BFCD_Designs tabke. Is this correct for where statement.
What is correct syntax?

Code:
Where MAX BFCD_Designs.Revision