From: grep <cb@onsitetech.com>
To: pgsql-sql@postgresql.org
Subject: Bad design or SQL statment quandary
Date: Tue, 26 Feb 2002 21:53:06 -0800
Message-ID: <a5hs0r$nhh$1@jupiter.hub.org> (raw)
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];
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cb@onsitetech.com
Subject: Re: Bad design or SQL statment quandary
In-Reply-To: <a5hs0r$nhh$1@jupiter.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox