I have a table containing information about boats make model price etc

In a seperate table I have the image information

One boat my have more than one image

I want to show a given record but only the first picture

I join the recordsets using a unique identifier

Select *
From tbla, tblb
Where tbl.boatid = tblb.boatid

But if there are three pictures it shows as 3 boats in my repeat region