Received: from wolff.to (wolff.to [66.92.219.49]) by postgresql.org (Postfix) with SMTP id 87CDC475A55 for ; Wed, 27 Feb 2002 08:19:36 -0500 (EST) Received: (qmail 9959 invoked by uid 500); 27 Feb 2002 13:21:49 -0000 Date: Wed, 27 Feb 2002 07:21:49 -0600 From: Bruno Wolff III To: grep Cc: pgsql-sql@postgresql.org Subject: Re: Bad design or SQL statment quandary Message-ID: <20020227132149.GA9943@wolff.to> Mail-Followup-To: grep , pgsql-sql@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.25i X-Archive-Number: 200202/428 X-Sequence-Number: 6849 On Tue, Feb 26, 2002 at 09:53:06PM -0800, grep wrote: > I have 2 tables: 'people' and 'project'. The 'people' table keeps info on > the key players in a project. The 'project' table keep the project info > including the roles the people in 'people' table play. I store the people_id > in the 'project' table. I am at a loss to pull the names from 'people' table > with a SELECT on the project table. So my questions are: > 1. what am missing to complete the SELECT? > 2. Or is this just bad design on my part? and I should break this info out > to 'roles' table? > > Table 'people' > -------------- > people_id > name > email > > Table 'project' > -------------- > proj_id > description > proj_mgr > lead_devel > qa_tester > While role table might be a better way to do things, depending on the kinds of questions that you ask and whether at some point you might expect to find multiple people filling the same role on a project, you can get what you want now. select name from people, project where proj_id = 'PROJ_ID_YOU WANT' and (people_id = proj_mgr or people_id = lead_devel or people_id = qa_tester);