Query returns unexpected users. Not using join.

[darthmahon]

Hi Guys,

Having a bit of a problem trying to get the correct results. Basically I have three tables I need to select from; user, platform and game.

I'm running the following query

select distinct 
	u.user_name, 
	u.user_avatar, 
	u.user_rating 
from 
	user_game ug, 
	platform p, 
	user u 
where 
	ug.game_id = 1
	and p.platform_id = 1
	and u.user_country = 1

Basically I want it to return users who own the game "1", have it on platform "1" and live in country "1".

Unfortunately does not return users who meet ALL WHERE criteria.

Any ideas where I am going wrong? I know an alternative is to use JOINS but I don't want the performance to be hit by doing that.

Cheers,
Chris

[Piranha]

You can't select from more than one table if you don't use join. Or to be correct, you can but you will get a result with far to many posts, like this:

SELECT user.name, team.name FROM user, team WHERE user.id = 1;

This will return username from the user with id 1 combined with every occurance of team. So if you have 15 teams it will basically tall you that you are in all 15 teams.