Zapytanie
SELECT project.id_project_pk AS p_id, status.id_status_pk AS s_id, status.name AS s_name, account.id_account_pk AS w_id, account.name AS w_name, account.lastname AS w_lastname, account.id_account_pk AS c_id, account.name AS c_name, account.lastname AS c_lastname, project.netto_price AS p_netto, project.brutto_price AS p_brutto, project.add_time AS p_add_time, project.dead_time AS p_dead_time
FROM project, status, account
WHERE s_id = project.id_status_fk AND w_id = project.id_worker_fk AND c_id = project.id_client_fk
zwraca następujący błąd:
#1054 - Nieznana kolumna 's_id' w where clause
Dlaczego zapytanie zwraca taki błąd? Pozdrawiam.