Received: from jupiter.hub.org (jupiter.hub.org [64.49.215.5]) by postgresql.org (Postfix) with ESMTP id 0F7554758F2 for ; Wed, 27 Feb 2002 01:02:21 -0500 (EST) Received: (from news@localhost) by jupiter.hub.org (8.11.6/8.11.6) id g1R5nFh24128 for pgsql-sql@postgresql.org; Tue, 26 Feb 2002 23:49:15 -0600 (CST) (envelope-from news) From: "grep" X-Newsgroups: comp.databases.postgresql.sql Subject: Bad design or SQL statment quandary Date: Tue, 26 Feb 2002 21:53:06 -0800 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 35 Message-ID: X-Complaints-To: news@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 To: pgsql-sql@postgresql.org X-Archive-Number: 200202/418 X-Sequence-Number: 6840 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 TIA -- grep #!/usr/bin/perl $_='grep';@a=(g..r,e..p);printf("%c%c%c%c",(y;grep;map;)+70,65,length(join(' ;',reverse(split //,++$_)))+$#a+50,s;mapq;grep\;grep\;grep;+56+y;g;j;+y;r;a;+y;e;p;+y;p;h;);$ _=(split/;/)[0];