[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