Interesting question.

[sfullman]

Hi there,

In this case a table is worth a thousand words, so here's a link to what I'm trying to do.

http://samuelfullman.com/relatebase/sql_question.htm

You can probably notice that someone can be an administrator of one account and a user in another one.

Suppose "rexguestcompasspt" wants to log in with that UserName. His email is [e-mail], right? So I also want to show the record that says he's an administrator for losthorizon.

Here's the question: how do I say:

"find the record where UserName = this value (rexguestcompasspt), take the resulting Email field, and also match records where Email = that resulting Email field."

??

I could do it in two consecutive queries but I really want to do it in one.

Any Advice?
Sam Fullman
Compass Point Media

[nostradamus]

select * from table where Email in (select Email from table where UserName = "username");

[Anon]

select t2.*
from mytable t1
inner join mytable t2
on t1.Email = t2.Email
where t1.UserName = rexguestcompasspt