I'm getting this error message when I try to load my page:

"Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM titles INNER JOIN premieres ON dateid = premieres.id' at line 3"

Here is my code:

PHP Code:
try
{
  
$sql 'SELECT titles.id, Title, name, directors.link, dateid 
      FROM titles INNER JOIN directors ON directorid = directors.id
      FROM titles INNER JOIN premieres ON dateid = premieres.id'
;
  
$result $pdo->query($sql); 
Please tell me what I'm doing wrong.