View's SELECT contains a subquery in the FROM clause

This error message usually occurs when you have a subquery in the FROM clause of your SELECT statement and the subquery returns more than one column. To fix this error, you can either modify the subquery to return only one column, or you can use a join instead of a subquery.

Here's an example of a subquery in the FROM clause that would cause this error:

SELECT *
FROM (SELECT col1, col2
      FROM table1) subquery

To fix this, you could modify the subquery to only select one column:

SELECT *
FROM (SELECT col1
      FROM table1) subquery

Or you could use a join instead:

SELECT *
FROM table1
JOIN table2 ON table1.id = table2.id