Re: JOINING TWO TABLES

--- vamseelist(at)gmail(dot)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.