> Here's what I did. Based on the same query (the one you
> provided) as below
> I executed the following:
>
> select mgrname, pjname from managers, projects, pocs
> WHERE pjid = 'x'
> AND pocs.pjid = projects.pjid
> AND pocs.pmyid = 'x'
> AND pocs.altid = 'x'
> AND (pocs.pmyid = managers.pmyid
From: "David Gilmour" <[EMAIL PROTECTED]>
To: "Randy Hammons" <[EMAIL PROTECTED]>
Sent: Monday, October 28, 2002 8:31 PM
Subject: Re: i almost hate queires, please help!!!
> Randy,
>
> See below
> - Original Message -
> From: "Randy Hammons
you have to include relations to all the tables you've selected from.
select mgrname, pjname
from managers, projects, pocs
where pjid = 'x'
and pmyid = 'x'
and altid = 'x'
AND POCs.PjID = PjStatus.PjID AND POCS.pmyid = Managers.PrimaryID AND POCS.altid = Managers.AlternateID
i think that is how y
here's my table syntax:
create table Projects
( PjID int unsigned auto_increment not null primary key,
PjNumber varchar(40) not null,
PjName tinytext not null,
PjDesc tinytext,
PJEcd varchar(30),
PJCost varchar(30),
LastUpdate char(30)
);
create table Managers
( MgrID int unsi
