SELECT patients.name, meds.name, meds.dose FROM patients RIGHT JOIN meds ON patients.med_id = meds.med_id
As you can see this makes the information on the Right side (in this case its the "dose" from our second table) the priority so results are displayed even when there is no patient.
By using each of these types of joining you can easily create dynamic reports from your data.
