Getting variable from first table in Left Join

[subha86]

So I have a basic question of how to get a variable from the a table of a outer join statement.\[code\]mysql_query("SELECT * FROM (cal_events left join cal_cities on cal_events.city_id = cal_cities.id) left join cal_genre on cal_events.genre_id = cal_genre.id WHERE start_day BETWEEN DATE_ADD(CURDATE(), INTERVAL -1 DAY) AND DATE_ADD(CURDATE(), INTERVAL 5 DAY) order by start_day");while($info = mysql_fetch_array( $data )) { echo $info['id'];}\[/code\]This will echo out the genre's id, but I need the id from cal_events... using $info['cal_events.id'] just throws errorsHELP!