[SOLVED] #1054 - Nieznana kolumna 'ps_customer.id_customer' w on clause

Cześć,

Mam pytanie jak w temacie. Po wywołaniu zapytania:

select c.firstname, c.lastname, c.email, c.optin, c.newsletter FROM ps_customer as c INNER JOIN ps_address ON ps_customer.id_customer=ps_address.id_customer

leci błąd:

#1054 - Nieznana kolumna 'ps_customer.id_customer' w  on clause

tabela ps_customer ma kolumne id_customer. Stąd nie rozumiem tego problemu. Z góry dzięki za pomoc.
Pozdrawiam

--rozwiązanie

select c.firstname, c.lastname, c.email, c.optin, c.newsletter, city FROM ps_customer as c INNER JOIN ps_address ON ps_address.id_customer = c.id_customer