i have the following stored procedure right now....
select i.PGImageID, i.Headline, i.Description, i.PGImageURL
from PGImage i
Inner Join PGGallery g ON i.PGImageID = g.Image1
Where g.GalleryID = (Select TOP 1 GalleryID From PGGallery ORDER BY DateAdded DESC)
The PGGallery table has the following columns: Image1, Image2, Image3, Image4, Image5
I am trying to get the information for each image like I have done for Image1 in the stored procedure above.
Is this possible to do it all in one stored procedure??? Please, someone help me asap because i am on a tight deadline.
thanks in advance