Hi ,

Thanks for the response. Have attached a sample excel which contains the structure of csv file that I will import , and two other tables. I have given the expected output table as well.

I have more than 100 tables with me and each table has different primary column. My requirement is to get the count of all primary columns of all the tables.

Instead writing the count query 100 times, I am trying to achieve that in single query.

Hope it clarifies.

Thanks again