PDA

View Full Version : How to display result sets of 2 tables in SQL using setQuery?



babygal
20th September 2010, 08:22
The code below can only display result sets of 1 of the table(TABLE1 in MYSQL):

QSqlQueryModel *model = new QSqlQueryModel;
model->setQuery("SELECT field1,field2,field3 FROM TABLE1");
model->setHeaderData(0, Qt::Horizontal, QObject::tr("Field 1"));
model->setHeaderData(1, Qt::Horizontal, QObject::tr("Field 2"));
model->setHeaderData(2, Qt::Horizontal, QObject::tr("Field 3"));

if(model->lastError().isValid())
qDebug() << model->lastError();

QTableView *view = new QTableView;
view->setModel(model);
view->show();

How to display result sets of 2 tables(TABLE1 and TABLE2 in MYSQL) in one data model?

wysota
20th September 2010, 08:46
"SELECT t1.field1, t1.field2, t2.field1, t2.field2 from table1 t1 JOIN table2 t2 ON <join condition goes here>"