Babelfish : UPDATE query with JOIN – Postgresql
I have the following sample data: create table employee (id int,emp_name varchar(50),project_name varchar(50)); insert into employee(id,emp_name) values(1,'Smith'); insert into employee(id,emp_name) values(2,'Jill'); insert into employee(id,emp_name) values(3,'Hana'); create table employee_project (emp_id int,project_id int); insert into employee_project(emp_id,project_id) values(1,101); insert into employee_project(emp_id,project_id) values(2,201); insert…