Joined Subquery in Access 2002
-
I have the following:
SELECT * FROM Article, Member, Album
LEFT JOIN
( SELECT *
FROM
linkArticleAlbum, Photo, Album
WHERE
linkArticleAlbum.Album = Photo.Album AND
linkArticleAlbum.Album = Album.ID AND
Photo.IsIcon = true ) As AlbumLink
ON AlbumLink.linkArticleAlbum.Article = Article.ID
WHERE
Article.Author = Member.ID AND
Article.Team = 1
ORDER BY Article.DateCreated DESC, Article.TitleHow can I do this in Access 2002? You see that I need to get the photo that represents the icon for the album on every occasion where the article is linked with an album. I'm stumped. I'm also a bit of a newb when it comes to subqueries and the way things are referenced. -------- to die is gain
-
I have the following:
SELECT * FROM Article, Member, Album
LEFT JOIN
( SELECT *
FROM
linkArticleAlbum, Photo, Album
WHERE
linkArticleAlbum.Album = Photo.Album AND
linkArticleAlbum.Album = Album.ID AND
Photo.IsIcon = true ) As AlbumLink
ON AlbumLink.linkArticleAlbum.Article = Article.ID
WHERE
Article.Author = Member.ID AND
Article.Team = 1
ORDER BY Article.DateCreated DESC, Article.TitleHow can I do this in Access 2002? You see that I need to get the photo that represents the icon for the album on every occasion where the article is linked with an album. I'm stumped. I'm also a bit of a newb when it comes to subqueries and the way things are referenced. -------- to die is gain
-
why don't you try creating the subquery and saviong as a view - then simply join the table to the query (by name) and use QBE window. Keep it simple!