Doing a Subquery in SQL

Posted on : June 23, 2005 10:00 AM | Posted by : Troy
Related Categories: SQL

For my own future reference... This will lookup a value (emailaddress) from table2, to use in where clause in table1.

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

Comments (0) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 430 Views
Comments

There are no comments for this entry.

[Add Comment]
BlogCFC was created by Raymond Camden. This blog is running version 5.9.002. Contact Blog Owner