left join Opcje

[deniol13]

witam, mam takie zapytanie

[SQL] pobierz, plaintext 
SELECT f.*, t.* FROM forums f
LEFT JOIN topics t 
WHERE f.forum_id = t.forum_id
ORDER BY t.topic_start_date DESC
LIMIT 0, 1
[SQL] pobierz, plaintext 

efekt w pma
#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 'WHERE f.forum_id = t.forum_id
ORDER BY t.topic_start_date DESC
LIMIT 0, 1' at line 3

[Mchl]

LEFT (RIGHT) JOIN wymaga warunku złączenia w ON

Kod

SELECT f.*, t.* FROM forums f
LEFT JOIN topics t
ON f.forum_id = t.forum_id
ORDER BY t.topic_start_date DESC
LIMIT 0, 1