select from 2 tables and

[abramov]

Hello, im new to mysql and i could find anything on the internet to help me so ill post my q here.

First im running mysql 5.0.67. I have to tables

allusers:
-id_user
-help
-team_user
-own_emal

players:
-id_player
-name_player
-owner_name
-owner_id
-owner_team_id

So this is my 2 tables. What im trying to do is reading from this tables to look if id_user is the same number with owner_team_id , and if it is the same show only stats that is from specific user

Thank you
Michael

[mwasif]

I didn't understand you completely. Are you looking for this?

SELECT * FROM allusers users 
INNER JOIN players p ON p.owner_team_id = users.id_user
WHERE users.id_user = 'some user id here'

[daniel2335]

If you give those two columns the same name you could use something like this..

SELECT * FROM users  
LEFT JOIN players USING (id_user)
WHERE id_user = 'user id'