Fulltext søgning over flere tables
HeyKan man ikke bruge flere tables i en fulltext søgning:
SELECT
title,
MATCH (track.title, contributor.displayName) AGAINST ('live') AS score,
contributor.displayName
FROM track
LEFT JOIN
trackContributor ON trackContributor.productId = track.productId AND trackContributor.role = 'DisplayArtist'
LEFT JOIN
contributor ON contributor.id = trackContributor.id
WHERE
MATCH (track.title, contributor.displayName) AGAINST ('live') LIMIT 20
= fejl 1210 - Incorrect arguments to MATCH