Hi Katy,

Just so you know. If a lookup is defined LabKey SQL provides a simple syntax to refer to the joined table. For instance if "well" has a foreign key (lookup) defined, and the target table has a column called "name" you can simply use this syntax.

WHERE well.name = 'A01'

The "." in the "well.name" does the left outer join for you. Hope that's helpful.