|
|
There was a problem opening the record set: Object invalid or no longer set. 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 = 23191 AND xxSongSong.SameAs = 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 = 23191 AND xxSongSong.SameAs = True ORDER BY Song.Song, Artist.Artist; |