I'm guessing...  use a join?

So, I'm trying to learn more about complex queries, and I have a feeling the result for this question is going to end up as a short tutorial in joins.  I'll use generic info here.

Let's say I have three tables:

table: PEOPLE
fields: id, fullname, email, phone

table: ERROR_TYPES
fields: id, short_desc, long_desc, send_email

table: ERRORS
fields: id, person_id, error_type_id, date

I'd like to run a single query that returns all rows in ERRORS, but rather than returning the person_id and error_type_id stored in the table, it returns the fullname from PEOPLE and the short_desc from ERROR_TYPES associated with those ids.

Any assistance in understanding how such a query would work would be very helpful.

Thank you!
~MikeyStart Free Trial