Here is the query with the three fields left joined that isn't working:
Expand|Select|Wrap|Line Numbers
- SELECT Base.LoanId_fk
- , Base.TaskId_pk
- , Base.Description
- , Base.TaskOrder
- , Base.ValueLocation
- , LoanValue.FieldName
- , LoanValue.FieldValue
- FROM tqryTasks_Pro_Base AS Base
- LEFT JOIN
- tqryTasks_Pro_LoanValue AS LoanValue
- ON (Base.ValueLocation = LoanValue.ValueLocation)
- AND (Base.LookupValue = LoanValue.FieldName)
- AND (Base.LoanId_fk = LoanValue.LoanId_pk);
Expand|Select|Wrap|Line Numbers
- SELECT Base.LoanId_fk
- , Base.TaskId_pk
- , Base.Description
- , Base.TaskOrder
- , Base.ValueLocation
- , LoanValue.FieldName
- , LoanValue.FieldValue
- FROM tqryTasks_Pro_Base AS Base
- LEFT JOIN
- tqryTasks_Pro_LoanValue AS LoanValue
- ON (Base.LookupValue = LoanValue.FieldName)
- AND (Base.LoanId_fk = LoanValue.LoanId_pk);