|
|
There was a problem opening the record set: Cannot open any more tables. SELECT Song.*, Artist.* FROM ((xxSongSong LEFT JOIN Song ON xxSongSong.SongID = Song.SongID) LEFT JOIN xxSongArtist ON Song.SongID = xxSongArtist.SongID) LEFT JOIN Artist ON xxSongArtist.ArtistID = Artist.ArtistID WHERE xxSongSong.RelatedSongID = 8263 AND xxSongSong.SampleOf = True UNION SELECT Song.*, Artist.* FROM ((xxSongSong LEFT JOIN Song ON xxSongSong.RelatedSongID = Song.SongID) LEFT JOIN xxSongArtist ON Song.SongID = xxSongArtist.SongID) LEFT JOIN Artist ON xxSongArtist.ArtistID = Artist.ArtistID WHERE xxSongSong.SongID = 8263 AND xxSongSong.SampleIn = True ORDER BY Song.Song, Artist.Artist; |