Hi! I'm trying to do a LEFT JOIN query on two tables in my database, and everything works just fine with the QSqlQuery object. However, I've been using the record() method to get an record object for the current row so that I can access the database columns by name instead of index.

However, this doesn't work with multiple tables - the table names are stripped out of the column names. So I can't do something like value("table1.column_name") - instead, the column names are mixed with each other.

What should I do?