Compare and retrieve numbers in SQL
Actsin table Stars table Movies table
Starid Movienum Starid Gname Fname Movienum Title Yearreleased
100 1000 100 Matt Damon 1000 God 2002
Actsin, Stars, Movies are three different tables.
How can I get "Matt Damon"'s most recent movie with the movie name and
year released?
I got stuck at how to compare and get the latest year.
No comments:
Post a Comment