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...