What is the best way to display a Join between 2 or 3 tables? QSqlQueryModel?

[jdent]

I want to display a join of 2 or more tables selecting which columns I want to display and in what order...
Is QSqlQueryModel the way ... is there an example?

[JonB]

@jdent
Yes, QSqlQueryModel is the way to do this.

Don't know what you need an "example" for --- just call setQuery() with whatever query you want, presumably including JOIN(s), what else is there to say? If you really want do a Google for qsqlquerymodel join and have a look through some of the matches.

[jdent]

@JonB Ok, I thought there was more explicit support for joins, but it appears we only place the query string and that's it

Thanks anyway!

[JonB]

@jdent said in What is the best way to display a Join between 2 or 3 tables? QSqlQueryModel?:

Ok, I thought there was more explicit support for joins

Yes, there isn't :) Qt provides low-ish level support for database table access, nothing fancy, nothing for an arbitrary JOIN. The only "extra" is QSqlRelationalTableModel Class, which implements a specific JOIN for a foreign key. There will be third-party code, e.g. KDAB, out there which builds another layer on top if you want it.