To wrap up, consider a much more complicated SQL expression. Here's one that joins both tables to get names, selects specific columns, and fetches rows with a certain priority.

Many people are confused by various JOIN operations supported by SQL. Learn to master the SQL command line with this crash course in JOIN syntax.