Dear all I have users table and cars table.
and I have following join query:
select users.id as user_id, users.username, users.job, cars.id, cars.brand as car_brand FROM users LEFT JOIN cars on users.id = cars.user_id GROUP BY users.username, users.id, cars.id;
Here is the snapshot:
How to query for users that having cars more than one?
I tried code below but it return empty data:
How to get users that having more than one cars? (username: Ismed)