SELECT patients.name, meds.name, meds.dose FROM patients LEFT JOIN meds ON patients.med_id = meds.med_id
As you see, in this case using the LEFT JOIN gives us the same results that our WHERE did above. The difference is that even if there is no data in the second table, a result from the first table will be displayed and the second entry will be NULL.
