Add another line to the INNER JOIN mysql

Question

FROM notifications INNER JOIN users ON users.vk_id = notifications.from

How to add to INNER JOIN is:

 или notifications.from = 0

That is something like this:

 ON users.vk_id = notifications.from || ON notifications.from = 0

But I do not know the syntax. Help :(

Drac5 Drac5 2,611 7 15 · Accepted Answer · 2012-12-30T15:34:14

Like this:

 FROM notifications INNER JOIN users ON (users.vk_id = notifications.from OR notifications.from = 0)

1 answer 1