Devo creare una vista, questo è il codice, mi esce un errore nella prima riga ... near 'patents`.`patentsearch` AS
SELECT patents.*

REPLACE VIEW `patents`.`patentsearch` AS
SELECT patents.*,
GROUP_CONCAT(DISTINCT CONCAT(applicants.name,' (',applicants.country,')') SEPARATOR '; ') AS applicants,
GROUP_CONCAT(DISTINCT CONCAT(inventors.name,' (',inventors.country,')') SEPARATOR '; ') AS inventors,
GROUP_CONCAT(DISTINCT CONCAT(classifications.classification,'') SEPARATOR '; ') AS classifications
FROM (((patents LEFT JOIN inventors ON patents.applicationNumber=inventors.applicationNum ber)
LEFT JOIN applicants ON patents.applicationNumber=applicants.applicationNu mber)
LEFT JOIN info ON patents.applicationNumber=info.applicationNumber)
LEFT JOIN priorities ON patents.applicationNumber=priorities.applicationNu mber
LEFT JOIN classifications ON patents.applicationNumber=classifications.applicat ionNumber
GROUP BY patents.applicationNumber;


Secondo voi quale è l'errore?