sql query customers and language

[edsmiths]

Hello all., happy new year,

 

I need help in the sql manager. I'm trying to retrieve from ps database a list of customers (name, email and country) with the language used in the registration process. Is this possible?

 

Thanks in advance.

 

Ed

[tuk66]

SELECT c.lastname, c.firstname, c.email, l.name
FROM ps_customer c
LEFT OUTER JOIN ps_lang l ON l.id_lang = c.id_lang

Only country is ambiguous, because customers can have many different addresses.

[edsmiths]

Great!,

 

Thanks mate