Ciao a tutti
ho un errore con questa subquery, qualcuno mi puo' aiutare?
Codice PHP:
SELECT Person.Name FROM Person WHERE PersonID IN
(SELECT PersonPseudonym.PseudonymID FROM PersonPseudonym WHERE PersonPseudonym.PersonID = 115)
SELECT
person.`Name`,
personpseudonym.PseudonymID,
personpseudonym.PersonID,
person.PersonID
FROM
person
INNER JOIN personpseudonym ON person.PersonID = personpseudonym.PersonID
WHERE person.PersonID = 115
risultato
SELECT Person.Name FROM Person WHERE PersonID IN
(SELECT PersonPseudonym.PseudonymID FROM PersonPseudonym WHERE PersonPseudonym.PersonID = 115)
SELECT
person.`Name`,
personpseudonym.PseudonymID,
personpseudonym.PersonID,
person.PersonID
FROM
person
INNER JOIN personpseudonym ON person.PersonID = personpseudonym.PersonID
WHERE person.PersonID = 115
> 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 'SELECT
person.`Name`,
personpseudonym.PseudonymID,
personpseudonym.PersonID,
' at line 3
> Time: 0s