create view by joining 4 tables, insert data error

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
jasgames
User
Posts: 26

create view by joining 4 tables, insert data error

Post by jasgames »

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 :)


mobhar
User
Posts: 11660

Post by mobhar »

You may search in this forum by using UpdateTable keyword.


Post Reply