Mysql query:Select Field value

[sandeepsandeep]

Hellow

i am facing a problem in mysql query plesae solve it.

I have a table Team_master with two field

1. team_id
2. team_name 
 

And another table league_team with three field

1.id
2.team_id
3.league_id
 

in first team team_master data is

1   Boston
2   Monaco
3   manchaster
4   Others
 

second table league_master has

id  team_id  leage_id
1   2        1
2   3        1
3   1        2
4   2        2
 

My problem is when i am select league id =3 or 2 the found the team name correspondence of league.So any one can tell me how found the team_name if i am select any league ina single query.

when i am select the league id =2 them found the team_id so how will i found the name of team in a single row

Thanks,
Sandeep

[Atli]

Ok.

If I'm understanding correctly, you need to find every team that matches a league_id?

To do this you can JOIN the tables. This can be done like this

SELECT team.team_name FROM teamTbl AS team
INNER JOIN team_leagueTbl AS league 
  ON league.team_id = team.team_id
WHERE legue.league_id = 2;
 

P.S.
I don't have the means to test the query right now but I will as soon as I can.

[sandeepsandeep]

Lots of Thanks,

This query is work perfectlly....

Bye...

Ok.

If I'm understanding correctly, you need to find every team that matches a league_id?

To do this you can JOIN the tables. This can be done like this

SELECT team.team_name FROM teamTbl AS team
INNER JOIN team_leagueTbl AS league 
  ON league.team_id = team.team_id
WHERE legue.league_id = 2;
 

P.S.
I don't have the means to test the query right now but I will as soon as I can.