--this will give you last 4 entered album details with singname
SELECT DISTINCT TOP 4 albums_table.ID,albumname, albumprice, singer,singName,
FROM albums_table
INNER JOIN madia_table ON albums_table.ID=madia_table.albumID
WHERE singName='summer' -- you can pass where condition here
ORDER BY createDate DESC