i know you can't other columns, this is my problem.

let's say-

albums_table-

ID, albumname, albumprice, singer

madia_table

ID, albumID, singName, singPrice, createDate

now, what i need "get all the data of each song from the last 4 albums... so if i entered new albums "summer", "winter",

i need to get the last sing in "summer" and all the data (album data and sing data)

and the last sing in "winter" and all the data