join is not working

[godlesplay]

hi could anyone help me? I want join two tables into one, this code is working on my friends qt+db2 but on my qt+ingres isn't.

void FouDialog::on_pushButton_4_clicked()
{
    int num_rows, r, c;
    QSqlQuery q(db);
 
    if(!q.exec("SELECT count(id_wizyty) as num_rows FROM wizyta")) qDebug() << q.lastError().text();
    q.first();
    num_rows = q.value(0).toInt();
 
    ui->tableWidget->setRowCount(num_rows);
 
    //if(!q.exec("SELECT * FROM wizyta ")) qDebug() << q.lastError().text();
    if(!q.exec("SELECT id_wizyty, data, w.id_pacjenta, id_lekarza, p.imie as Imie_Pacjenta ,p.nazwisko as Nazwisko_Pacjenta FROM wizyta w JOIN pacjent p ON w.id_pacjenta = p.id_pacjenta")) qDebug() << q.lastError().text();
    for(r = 0, q.first(); q.isValid(); q.next(), ++r){
        for(c = 0; c < 6; ++c){
            ui->tableWidget->setItem(r,c, new QTableWidgetItem(q.value(c).toString()));
        }
    }
}

void FouDialog::on_pushButton_4_clicked()
{
    int num_rows, r, c;
    QSqlQuery q(db);

    if(!q.exec("SELECT count(id_wizyty) as num_rows FROM wizyta")) qDebug() << q.lastError().text();
    q.first();
    num_rows = q.value(0).toInt();

    ui->tableWidget->setRowCount(num_rows);

    //if(!q.exec("SELECT * FROM wizyta ")) qDebug() << q.lastError().text();
    if(!q.exec("SELECT id_wizyty, data, w.id_pacjenta, id_lekarza, p.imie as Imie_Pacjenta ,p.nazwisko as Nazwisko_Pacjenta FROM wizyta w JOIN pacjent p ON w.id_pacjenta = p.id_pacjenta")) qDebug() << q.lastError().text();
    for(r = 0, q.first(); q.isValid(); q.next(), ++r){
        for(c = 0; c < 6; ++c){
            ui->tableWidget->setItem(r,c, new QTableWidgetItem(q.value(c).toString()));
        }
    }
}

To copy to clipboard, switch view to plain text mode