subject:"\[SQL\] JOIN condition confusion"

Re: [SQL] JOIN condition confusion

2005-11-04 Thread Richard Huxton

Thomas Good wrote: Hi, I am wondering if there is a way to set conditions on a left joined table without hosing the join altogether: query = qq |SELECT p.*, a.user_id FROM patient_dosing p LEFT JOIN patient_assignment a ON p.patient_id = a.patient_id

[SQL] JOIN condition confusion

2005-11-03 Thread Thomas Good

Hi, I am wondering if there is a way to set conditions on a left joined table without hosing the join altogether: query = qq |SELECT p.*, a.user_id FROM patient_dosing p LEFT JOIN patient_assignment a ON p.patient_id = a.patient_id WHERE p.dose_