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?

Expand|Select|Wrap|Line Numbers

 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..

Expand|Select|Wrap|Line Numbers

 
SELECT * FROM users  

LEFT JOIN players USING (id_user)

WHERE id_user = 'user id'

select from 2 tables and

re: select from 2 tables and

re: select from 2 tables and

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about