Update Query from two tables based on a condition
Posted on 2014-02-11
I have two tables that I need to pull information from but only when a condition occurs in one of the tables.
When the field in SortYesNo = "Yes" in QREVALUE, I want to update the table SortDetail with the fields listed below.
The fields that I want to pull from QREVALUE are
The fields that I want to pull from SkpiProblemLog
ScrapRecordTag is the primary key and is in all three tables.
I have never done anything like this and I really don't know if it is possible.