Question: extract Column C from all tables


I have 103 tables ( aal_l,  abf_l  etc )  which each has columns D, T, O, H, C  etc 

I want to exctract column C for all 103 table and store the result in a matrix


I know how to extract column C for one table


convert(connection:-ExecuteQuery("select C from aal_l", 'output' = Array), Matrix)


but how can it be done for multiple tables ...?

Please Wait...