create view by joining 4 tables, insert data error
Posted: Fri Sep 30, 2022 8:49 am
Hi Experts.
create view by joining 4 tables with a master field named vou_id (common in all tables)
tbl1 : vou_id int primary key auto inc, fld1, fld2, fld2,...
tbl2 : vou_id int, tbl2_id int primary key auto inc, fld1, fld2, fld2,...
tbl3 : vou_id int, tbl3_id int primary key auto inc, fld1, fld2, fld2,...
tbl4 : vou_id int, tbl4_id int primary key auto inc, fld1, fld2, fld2,...
An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1393 Can not modify more than one base table through a join view.
Any help.
Thanks in advance :)