Perform a JOIN IF row = X

[Tiago Conceição]

its is possible perform a JOIN if the row have a certain value?

example:

SELECT id, item, ... IF(id > 5, JOIN ..., nothing)

so i want perform a single SELECT with a JOIN if a id > 5, otherwise dont performe JOIN


Thanks