select title, year_made, karl.movies.id,
d.fnames + " " + d.lname as director,
a.fnames + " " + a.lname as actor
from karl.movies, karl.persons d, karl.persons a, karl.acts_in
where karl.movies.id = #url.id#
and d.id = karl.movies.director
and a.id = karl.acts_in.actor
and karl.movies.id = karl.acts_in.movie
Movies Details
Movie #url.id# not found
#HTMLEditFormat(title)#