SQL Query

[NZ_Kiwi]

I have looked at this code

$result = mysql_query ("select r.result_id, r.team1_id, t1.team_name_nick,r.team2_id,t2.team_name_nick,r.team1_score,r.team2_score, r.game_played from result as r left join team as t1 on (r.team1_id = t1.team_id) left join team as t2 on (r.team2_id = t2.team_id) where r.group_id = $list_group and r.comp_id = $comp_id order by r.list_order");

what is the r.result_id thing.... the feild is result_id so what the r. before it???

[planetsim]

from result as r

r is assigned to result so r represents results where its seent throughout the Query.

[NZ_Kiwi]

Originally posted by planetsim

from result as r

r is assigned to result so r represents results where its seent throughout the Query. [/B]

so what about the t1 and t2 ??

[ihcra]

like wise

LEFT JOIN team AS t1

so AS states an alias or shorthand for the database in question

saves typing team.blah_blah or results.blah_di_blah

the AS operator has some other useful benefits