MySQL Forums
Forum List  »  Newbie

Re: Need help with advanced Joins
Posted by: Mathijs Bronneberg
Date: November 02, 2009 03:46AM

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.

Options: ReplyQuote

Written By
Re: Need help with advanced Joins
November 02, 2009 03:46AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.