SELECT patients.name, meds.name, meds.dose FROM patients, meds WHERE (patients.med_id = meds.med_id)
We now have the person's name displayed with their medicine and dosage. You will notice that since we are now working with more than one table, we refer to the data fields as table.field. Also you will see that the WHERE clause pulls information from the second table ONLY if relevant to the first table. Try running this again without the WHERE clause. You will instead see all possible combinations.
