I want to join the 2 tables so that I can link 2 sets of fields.
Current script:
$query = "SELECT movie_name, people_fullname
FROM movie
LEFT JOIN people
ON movie_leadactor = people_id
ORDER BY movie_name";
What I want to do:
$query = "SELECT movie_name, people_fullname
FROM movie...