Why does nesting my SQL query cause mt_1.ID to be unknown and how can I fix it

0:01:09

Handling 'mt_1.ID Unknown' Error in Nested SQL Queries