Let's say you only wanna select the first column. Cannot, it says 'NO_COLUMN: A'.

=query({O2:P4;O8:P9},"select A")  

It is easy to select ALL columns.

=query({O2:P4;O8:P9},"select *")

CodePudding user response：

use:

=QUERY({O2:P4;O8:P9}, "select Col1")