select from 2 tables and

abramov · #1 March 9th, 2009, 05:28 PM

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 · #2 March 10th, 2009, 02:31 PM

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 · #3 June 30th, 2009, 09:23 AM

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

/bytes/development

/bytes/it

/bytes/about