I have two database tables, AdvertImages (imageid, AdvertInfoid, Imageurl) and Advertinfo (advertinfoid, AdvertType, Title, Description, Price) The table Advertimages can hold as many images as wanted for each advert.
What I want to do is create a query that allows me to show the 1st image for each advert along with the AdvertType, Name and price . I thought I could do this with a subquery but I'm not getting anywhere. The two tables are joined on advertinfo.advertinfoid = advertimages.imageid
Can someone help please?