Firstly, you need to check your table creation statement completely to make sure that each table in the view already exists.
Secondly，please check whether the field has the same field in other tables. If there is the same field, you need to indicate the table to which the field belongs in the select statement (for example, select Table.column).
If this does not solve your problem, please share us your table structure (CREATE TABLE …) and some sample data(INSERT INTO …) along with your expected result. So that we’ll get a right direction and make some test.
If you have any question, please feel free to let me know.
If the response is helpful, please click "Accept Answer" and upvote it.