raise exception_from_status(DatabaseError, fdb.fbcore.DatabaseError: (' SQLCODE: -104\n- Dynamic SQL Error\n- SQL error code = -104\n- Token unknown

Делаю запрос базе для получении данных из 2 таблиц

connect = fdb.connect(dsn='C:\c.gdb', user='sysdba', password='master')
cur = connect.cursor()
cur.execute("SELECT BOOK1.R001F, CAR_A103.R1024"
        "FROM BOOK1 LEFT OUTER JOIN CARD_A103"
        "ON BOOK1.R001F = CAR_A103.R1024")
result= cur.fetchall()
print(result)

выдаёт ошибку

raise exception_from_status(DatabaseError, self._isc_status, fdb.fbcore.DatabaseError: ('Error while preparing SQL statement:\n- SQLCODE: -104\n- Dynamic SQL Error\n- SQL error code = -104\n- Token unknown - line 1, column 56\n- LEFT', -104, 335544569)