{
  "dBType" : "MYSQL5",
  "name" : "MySQL5",
  "getPSDEDataQueryCodeExps" : [ {
    "expression" : "t1.`CREATEDATE`",
    "name" : "CREATEDATE"
  }, {
    "expression" : "t1.`CREATEMAN`",
    "name" : "CREATEMAN"
  }, {
    "expression" : "t1.`REALESTATEID`",
    "name" : "REALESTATEID"
  }, {
    "expression" : "t21.`REALESTATENAME`",
    "name" : "REALESTATENAME"
  }, {
    "expression" : "t1.`REALESTATEREALTORID`",
    "name" : "REALESTATEREALTORID"
  }, {
    "expression" : "t1.`REALESTATEREALTORNAME`",
    "name" : "REALESTATEREALTORNAME"
  }, {
    "expression" : "t1.`REALTORID`",
    "name" : "REALTORID"
  }, {
    "expression" : "t11.`REALTORNAME`",
    "name" : "REALTORNAME"
  }, {
    "expression" : "t1.`UPDATEDATE`",
    "name" : "UPDATEDATE"
  }, {
    "expression" : "t1.`UPDATEMAN`",
    "name" : "UPDATEMAN"
  } ],
  "queryCode" : "SELECT\nt1.`CREATEDATE`,\nt1.`CREATEMAN`,\nt1.`REALESTATEID`,\nt21.`REALESTATENAME`,\nt1.`REALESTATEREALTORID`,\nt1.`REALESTATEREALTORNAME`,\nt1.`REALTORID`,\nt11.`REALTORNAME`,\nt1.`UPDATEDATE`,\nt1.`UPDATEMAN`\nFROM `T_REALESTATEREALTOR` t1 \nLEFT JOIN `T_REALTOR` t11 ON t1.`REALTORID` = t11.`REALTORID` \nLEFT JOIN `T_REALESTATE` t21 ON t1.`REALESTATEID` = t21.`REALESTATEID` \n",
  "id" : "PSMODULES/Test/PSDATAENTITIES/RealEstateRealtor/PSDEDATAQUERIES/View/PSDEDQCODES/MYSQL5.json"
}