数据表的联合查找

QStringList keys;

QList<QStringList> values;

keys<<"gui"<<"box"<<"sname"<<"sact"<<"ttime";

cmd = QString("select %2.%1 from %2 join %3 on %2.gui = %3.gui where %3.areaname='%4' and ttime>'%5' and ttime<'%6' order by %2.gui").arg(key,table,table1,areaname,time1,time2);

query.exec(cmd);

joinQueryOpenBoxRecord("t_manopen","t_unit",keys,ui->comboBox_area->currentText(),FromStr,ToStr,values);

联合查找图解：