Doing a Subquery

For future reference, this will lookup a value (email) from table2, to use in where clause in table1.


select *
from table1
where EmailAddress = (select EmailAddress from table2 where UserID = '#URL.UID#')