On Wednesday, July 02, 2014 02:38:36 PM jared wrote: > you have: > GROUP BY users.gender, measures.option > > instead try: > GROUP BY users > > *group by* on full table(*users*). I am away from our production DB. Could you tell me how this little change will solve the whole problem and help me to get the data as per the format I am looking for. -- ================ Regards, Arup Rakshit ================ Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it. --Brian Kernighan