Hello
You Want to Result Like That:-
productId,productTypeId,CatalogueId,imageId,imagepath So Simply You Can Use
SELECT f.productId,f.productTypeId,CatalogueId,imageId,imagepath
FROM finallevelcatalogue f
INNER JOIN imagemaster ON f.productId = imagemaster.productId
INNER JOIN
(
SELECT Top 1 ImageID, imagepath ,productId FROM imagemaster where productId=f.productId
) tab ON f.productId= tab.productId
It Will Give You ONe Recore Associated To PRoduct Id I Hope Your Problem Will Solve IF not Give me Your Review