Composers as performers
Home Page
Last Update 01/11/2006 -
recordings@online.fr
Erreur SQL !
SELECT artist.Year_Birth as YB, artist.Year_Death as YD, Instruments, a_performers.Last_Name, a_performers.First_Name, a_performers.Work_S, a_performers.Number, a_performers.Ref_Number, a_performers.Work, a_performers.Date_Place, artist.Last_Name, artist.First_Name, a_performers.Composer, performer.Id_Artist as IDA, a_performers.Id_Recording, a_performers.Performers_1, a_performers.Performers_2, a_performers.Ensemble, a_performers.Year_Birth, a_performers.Year_Death, a_performers.Ref1, a_performers.Ref2, a_performers.Ref3, artist.Composer FROM (artist INNER JOIN (instrument INNER JOIN performer ON instrument.Id_Instrument = performer.Id_Instrument) ON artist.Id_Artist = performer.Id_Artist) INNER JOIN (performers INNER JOIN a_performers ON performers.Id_Recording = a_performers.Id_Recording) ON performer.Id_Performer = performers.Id_Performer GROUP BY artist.Year_Birth, artist.Year_Death, Instruments, performer.Id_Artist, artist.Last_Name, artist.First_Name, artist.Year_Birth, artist.Year_Death, artist.Composer HAVING (((artist.Last_Name)<>"None")AND ((artist.Composer)=-1&m=1)) ORDER BY artist.Last_Name, artist.First_Name
Unknown column 'm' in 'having clause'