Even you can drop the manager table and only keep employees table containg
mangers and employees to and then self join the table.
and then query
select e.employee_name , e1.employee_name as manager_name from
employee e, employee e1
where e.manager_id=e1.employee_id
With Regards
Ashish
----- Original Message -----
From: "Richard Broersma Jr" <rabroersma@yahoo.com>
To: <vamseelist@gmail.com>; <pgsql-novice@postgresql.org>
Sent: Monday, August 06, 2007 9:57 PM
Subject: Re: [NOVICE] JOINING TWO TABLES
>
> --- vamseelist@gmail.com wrote:
>> I mean d,e got 1 and 2 in mgr table.
>> d,e got 4,5 in new table.
>>
>> I would like to replace 1 1 2 with 4 4 5.
>>
>> I would like to modify above table as
>
> I would modify your manager and employees tables to look like:
>
>
> CREATE TABLE Employees (
> emp_id SERIAL PRIMARY KEY,
> name text,
> mgr_id INTEGER);
>
> CREATE TABLE Managers (
> mgr_id INTEGER PRIMARY KEY REFERENCES Employees( emp_id ));
>
> ALTER TABLE Employees
> ADD CONSTRAINT managers_of_employees
> FOREIGN KEY ( mgr_id )
> REFERENCES Managers( mgr_id );
>
> Regards,
> Richard Broersma Jr.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
