Mybatis table join query _ MySQL

The mybatis table join query is used as the join query for three tables.

Sub-table in which cfm_requirement_vendor_date is cfm_requirement_vendor

The cfm_requirement_vendor is a subtable of cfm_requirement.

1. mybatis ing file definition

       
 
  
  
      
    
   
   
   
    
   
  
    
 SELECTr. id, r. requirement_id, v. id as requirement_vendor_id, v. vendor_id, d. id as requirement_vendor_date_id, FROMcfm_requirement rJOIN cfm_requirement_vendor v ON r. id = v. cfm_requirement_idAND v. del_flag = 0 join cfm_requirement_vendor_date d on v. id = d. cfm_requirement_vendor_id and d. del_flag = 0 WHEREr. requirement_id =#{ requirementId} and r. del_flag = 0

II. java class definition

1. mapper. java

List SelectNestedByRequirementId (int requirementId );

2. persistence object

public class NestedRequirement extends Requirement {    private List
 
   requirementVendorList;public List
  
    getRequirementVendorList() {return requirementVendorList;}public void setRequirementVendorList(List
   
     requirementVendorList) {this.requirementVendorList = requirementVendorList;}      }