[thelist] simple(?) SQL question

dave gray dascott at wam.umd.edu
Thu Sep 21 10:03:14 CDT 2000


hello SQL gods,

very simple (i hope) question to start off the day:
i'm trying to combine two queries that get their info from two different
tables (is there a special term for that?).

the two queries as they are now are:

select domain,acct_type from account where login='imalogin'
then based on that, i do:
select setup_fee,monthly_fee from plan where acct_type='from_above';

so what i want my new magical query to return is:
domain,acct_type,setup_fee,monthly_fee

except the two fees i want to get are in a different table and i don't
know the magic syntax for that!

TIA,

 -dave





More information about the thelist mailing list