I have a question...I have two tables, one with an ID number and year_made in it, and another one with a birth_date and death_date.
I'm trying to bring back ID numbers where the artist was 30 years of age or younger when the item was made. It requires a calulation to figure out the birth date + 30 years, and to return any id numbers where date_made falls into one of those 30 years between the birth_date and birth_date + 30.
However, I've not the foggiest on how to set it up in SQL. Or rather, I have too much fog, and not enough clear vision.