mysql> SELECT * FROM Actor, Cast WHERE mid = 210511;
Query aborted by Ctrl+C
ERROR 1317 (70100): Query execution was interrupted

mysql> SELECT * FROM Actor, Cast WHERE mid = 210511 AND Actor.id = Cast.aid;
+--------+----------------+--------------+--------+--------+--------+-----------------------------+
| id     | fname          | lname        | gender | aid    | mid    | role                        |
+--------+----------------+--------------+--------+--------+--------+-----------------------------+
|  49922 | Mark           | Boone Junior | M      |  49922 | 210511 | Burt Hadley                 | 
| 146916 | Russ           | Fega         | M      | 146916 | 210511 | Waiter                      | 
| 211557 | Larry (I)      | Holden       | M      | 211557 | 210511 | Jimmy Grantz                | 
| 274282 | Thomas (III)   | Lennon       | M      | 274282 | 210511 | Doctor                      | 
| 361482 | Joe            | Pantoliano   | M      | 361482 | 210511 | John Edward 'Teddy' Gammell | 
| 366618 | Guy (I)        | Pearce       | M      | 366618 | 210511 | Leonard Shelby              | 
| 395132 | Callum Keith   | Rennie       | M      | 395132 | 210511 | Dodd                        | 
| 474882 | Stephen        | Tobolowsky   | M      | 474882 | 210511 | Sammy Jankis                | 
| 495184 | Buzz           | Visconti     | M      | 495184 | 210511 | Motel guest                 | 
| 570616 | Kimberly (I)   | Campbell     | F      | 570616 | 210511 | Blonde Whore                | 
| 623436 | Jorja          | Fox          | F      | 623436 | 210511 | Catherine Shelby            | 
| 647469 | Harriet Sansom | Harris       | F      | 647469 | 210511 | Mrs. Jankis                 | 
| 729933 | Carrie-Anne    | Moss         | F      | 729933 | 210511 | Natalie                     | 
| 730692 | Marianne       | Muellerleile | F      | 730692 | 210511 | Emma the Tattooist          | 
+--------+----------------+--------------+--------+--------+--------+-----------------------------+
14 rows in set (0.00 sec)

mysql> SELECT fname,lname,role FROM Actor, Cast WHERE mid = 210511 AND Actor.id = Cast.aid;
+----------------+--------------+-----------------------------+
| fname          | lname        | role                        |
+----------------+--------------+-----------------------------+
| Mark           | Boone Junior | Burt Hadley                 | 
| Russ           | Fega         | Waiter                      | 
| Larry (I)      | Holden       | Jimmy Grantz                | 
| Thomas (III)   | Lennon       | Doctor                      | 
| Joe            | Pantoliano   | John Edward 'Teddy' Gammell | 
| Guy (I)        | Pearce       | Leonard Shelby              | 
| Callum Keith   | Rennie       | Dodd                        | 
| Stephen        | Tobolowsky   | Sammy Jankis                | 
| Buzz           | Visconti     | Motel guest                 | 
| Kimberly (I)   | Campbell     | Blonde Whore                | 
| Jorja          | Fox          | Catherine Shelby            | 
| Harriet Sansom | Harris       | Mrs. Jankis                 | 
| Carrie-Anne    | Moss         | Natalie                     | 
| Marianne       | Muellerleile | Emma the Tattooist          | 
+----------------+--------------+-----------------------------+
14 rows in set (0.00 sec)

mysql>