你也可以这样做,例如
SELECT `movie`.*, -- select all fields from one table movie_data.id as movieId -- and some fields of another table FROM `movie` LEFT JOIN movie_data ON movie.movie_id = movie_data.id ORDER BY movie.id