Re: Can you help me to solve this query problem?

[Chris Stubben]

Hi,

Try adding DISTINCT to the two count funtions, count( DISTINCT m.user_id ), count( DISTINCT o.user_id )

Also, remove the GROUP BY and count functions and you should see why this is happening. Basically, if you use aggregate functions and multiple joins, you need to deal with the Cartesian product that's returned.


SELECT
u.user_id
, u.surname
, u.firstname
,m.user_id AS localGroupMembers
,o.user_id AS orders
FROM
users AS u
LEFT JOIN
localGroupMembers AS m
ON u.user_id = m.user_id
LEFT JOIN
orders AS o
ON u.user_id = o.user_id
WHERE
u.user_id = "aca0c71d890f426db8d010427de0527b";




Chris