MerchantStatus
merchantid 外键
PCISAQ
PCIUpdatedDate
PCIConfirmedDate
Merchant
merchantid 主键
mid 唯一键
现在已知mid,修改mid为******的MerchantStauts 的列值 ,如下
update MerchantStatus set PCIStatus='Expired', PCISAQ='C', PCIUpdatedDate='2/2/2015' , PCIConfirmedDate='10/16/2013' from Merchant m
where MerchantStatus.merchantid=m.merchantid and m.mid='273200063009' ;