help query

[osusano]

hello there can someone help me with my query

i have tables ilke this

tbl_sched with the ff fields.
schedId
teamId
vs
date
time
gym

and i have a tbl_teams with the ff field
teamId
teamName

well basically i can join both of them now..

but my problem is that i am using 2 colums that has to be change via single query

like the teamId should be the team name
and the vs should give the team name too..

i can make 2 query to check this but do u think can this be done on a single query?

[YappyDog]

You should be able to do it by using table aliases and then having your teamName table in the query twice.

SELECT t1.teamName as Team1, t2.teamName as Team2
FROM tbl_sched, tbl_teams AS t1, tbl_teams AS t2
WHERE tbl_sched.schedId = t1.schedId
and tbl_sched.vs = t2.schedId;