Re: Need help with advanced Joins

[Mathijs Bronneberg]

Thank you for you help so far.

The query works, but I only see the customer userid. Name, age, gender columns aren't shown, as if they are not selected.

I changed 'eav' to 'cms_module_feusers_properties' which is the table that contains all the customer data (name,age,etc).

I'm also wondering why the MAX function is used.
(Without it, results don't show the name, age, gender either.)

So mainly I'm trying to figure out why I only see the userid from the 'cms_module_feusers_properties' table.

EDIT: the leftjoin you added has no function, if I delete it, the results look still the same.

EDIT2: srry, copied the query wrong. Results show the right colums, but the values are NULL



Edited 2 time(s). Last edit at 11/02/2009 04:00AM by Mathijs Bronneberg.