Re: AS in a statement

Peter Lauri wrote: Best group member, I do this query SELECT tour_player_score.strokes AS score, tour_scorecard_hole.par AS par, score-par AS overpar FROM `tour_player_score`, tour_scorecard_hole WHERE tour_player_id=175 AND tour_scorecard_hole.id=tour_player_score.scorecard_hole_id It gives

Re: AS in a statement

> Best group member, > > I do this query > > SELECT tour_player_score.strokes AS score, tour_scorecard_hole.par AS par, > score-par AS overpar > FROM `tour_player_score`, tour_scorecard_hole WHERE tour_player_id=175 AND > tour_scorecard_hole.id=tour_player_score.scorecard_hole_id > > It gives err