I am in need of help writing an update query.
I have a single table: [companycitymaster]
This table contains columns [state], [citycode] and [splc].
I need to update the state = 'QC' rows with the [splc] value where
state = 'PQ' BUT only if the state = 'QC' rows are blank and only where the [citycode] is equal.
I need to do this update before i delete all the pq's.
See data below.