Hi Dave, Have you tried: select a.domain, a.acct_type, p.setup_fee, p.monthly_fee from account a, plan p where p.acct_type=a.acct_type and a.login='imalogin'; Or something of the sort? Leo. ~ Leo P. Wiedersheim, Jr. leo at wiedersheim.com http://www.Wiedersheim.com http://www.CampaignCollectibles.com _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.