SQL - Part 64 - Using All Operator in Multi Row Sub Query

[@alluri5538]

Why iam getting could not prepare statement while running this command. Upto subquery it is working. After entering outer query. It showing like could not prepare statement showing. Please help me.

[@QAFox]

Provide more details and also provide the query your are trying, along with error details.

[@tanazahmed1440]

@@QAFox Error 1: could not prepare statement (1 near "all": syntax error) this is showing

[@nithinanthony626]

sir when we copy the command and execute the same in w3 schools it is not executing ... it shows Error 1: could not prepare statement (1 near "all": syntax error)

[@kakabraza8869]

Same problem how did u fix it

[@alluri5538]

Why iam getting could not prepare statement while running this command. Upto subquery it is working. After entering outer query. It showing like could not prepare statement showing. Please help me.

[@QAFox]

Provide more details and also provide the query your are trying, along with error details.