使用QSqlTableModel的时候，setTable设置从哪个表取数据，有没有办法用join ? [复制链接]

    model = new QSqlTableModel(this,db);
    model->setTable("emn_order_cache");
    model->select();

这样我会把emn_order_cache表里面所有的数据都取出来，
但是
我要怎么设置join条件？

我的sql语句
sql = "SELECT ed.dishname_zh_cn,eoc.iamount,edu.unitname_zh_cn,edp.price FROM emn_order_cache as eoc "
                    "join emn_dish as ed on eoc.idid=ed.did "
                    "join emn_dish_unit as edu on eoc.iduid=edu.duid "
                    "left join emn_dish_comment as edc on eoc.idcid=edc.dcid and eoc.idid=edc.did "
                    "join emn_dish_price as edp on eoc.idid=edp.did and eoc.iduid=edp.duid";