[RESOLVED] ambigous filed

[pastet89]

HI
I am using the following query:

SELECT
		users.user_id, users.email, 
		users.first_name, users.last_name, 
		users.last_login, users.created, users.status,
		countries.name AS country, provinces.name AS province, cities.name AS city, districts.name AS district,
		properties_count.properties_count
	FROM users
	LEFT OUTER JOIN countries ON countries.country_id = users.country_id
	LEFT OUTER JOIN provinces ON provinces.province_id = users.province_id
	LEFT OUTER JOIN cities ON cities.city_id = users.city_id
	LEFT OUTER JOIN districts ON districts.district_id = users.district_id
	LEFT OUTER JOIN (
		SELECT user_id, count(*) AS properties_count
		FROM properties
		GROUP BY user_id
	) AS properties_count ON properties_count.user_id = users.user_id

and I am getting that error:
Column 'country_id' in where clause is ambiguous
Can somebody help me?

[Weedpacket]

Are you sure that's the query it's failing on? It doesn't have a WHERE clause, let alone an ambiguous use of country_id.

[pastet89]

ok, I found it really it was in the other part of the code. I elemenated the problem by changing the WHERE country_id = 'X'
into
WHERE users.country_id = 'X' 😉
Anyway, 10x