Fehlersuche

[spond]

SELECT	t.date,
	p.name,
	c.name,
	t.product_count,
	t.amount,
	s.name,
	s.location,
	t.note
FROM	((((transactions AS t WHERE strftime('%Y', t.date) = '1985')
	INNER JOIN shops AS s ON t.shop = s.id)
	INNER JOIN products AS p ON t.product = p.id)
	INNER JOIN categories AS c ON t.category = c.id);

Kann mir bitte jemand sagen wo im obigen SQL(ite) Statement der Fehler in der Nähe vom WHERE ist oder vieleicht eine berichtigte Version posten? Danke!

[witte]

SELECT    t.date,
    p.name,
    c.name,
    t.product_count,
    t.amount,
    s.name,
    s.location,
    t.note
FROM  transactions AS t 
    INNER JOIN shops AS s ON t.shop = s.id
    INNER JOIN products AS p ON t.product = p.id
    INNER JOIN categories AS c ON t.category = c.id
    WHERE strftime('%Y', t.date) = '1985'

[spond]

besten dank