<!--- Retrieve Films and Related Actors from database --->
<CFQUERY NAME="GetFilmInfo" DATASOURCE="#REQUEST.DataSource#">
  SELECT 
    Films.FilmID, Films.MovieTitle, 
    FilmsActors.ActorID
  FROM Films, FilmsActors
  WHERE Films.FilmID = FilmsActors.FilmID
  ORDER BY Films.MovieTitle
</CFQUERY>

<HTML>
<HEAD><TITLE>Films and Actors</TITLE></HEAD>
<BODY>
<H2>Films And Actors</H2>

<!--- Display retrieved information in HTML table --->
<CFTABLE QUERY="GetFilmInfo" HTMLTABLE BORDER COLHEADERS>
  <CFCOL HEADER="Film ID" TEXT="#FilmID#">
  <CFCOL HEADER="Film Title" TEXT="#MovieTitle#">
  <CFCOL HEADER="Actor ID" TEXT="#ActorID#">
</CFTABLE>

</BODY>
</HTML>
