Google sheets combine query syntax-CodePudding

I have this as my first query =Query({'Cut request '!A2:S;'Out sent '!A2:S},"Select Col1,Col2,Col4,Col3,Col10,Col13,Col17,Col19 Where Col4 is not null",0)

I want to combine both with this QUERY(leadlist!A2:Q,"Select I,M Where A is not null",0)

I tried doing this but got an "Formula parse error" =Query(ARRAYFORMULA({'Connection request '!A2:S;'Message sent '!A2:S},"Select Col1,Col2,Col4,Col3,Col10,Col13,Col17,Col19 Where Col4 is not null",0};QUERY(leadgen!A2:Q,"Select I,M Where A is not null",0)}))

I can not figure out how to combine both to make it works

Please any help. Thanks in advance, appreciated.

CodePudding user response：

With exactly the same number of columns, it will be ok (as Sergey said). For instance :

={Query({'Cut request '!A2:S;'Out sent '!A2:S},"Select Col1,Col2,Col4,Col3,Col10,Col13,Col17,Col19 Where Col4 is not null",0);QUERY(leadlist!A2:Q,"Select  A,B,C,D,E,F,G,H Where A is not null",0)}