SELECT *, T.`Titel-Nr` AS `Titel-Nr`, F.`Titel-Nr` AS FKz, F.`Dat erfasst`, datediff(F.`Dat erfasst`, ) AS Ddiff from `Titel` AS T LEFT OUTER JOIN `Filme` AS F ON F.`Titel-Nr` = T.`Titel-Nr` where T.`Titel-Nr` = 186365
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 ') AS Ddiff from `Titel` AS T LEFT OUTER JOIN `Filme` AS F ON F.`Titel-Nr` = T.`T' at line 1