Turns out that it was just a typo , here is the correct code

SELECT 'AMID_MAPG' AS WORKBOOK

, COUNT(*) AS TOTAL_ROWS

FROM [AMIDMapping$]

UNION ALL

SELECT 'BUS_AREA_RTS' AS WORKBOOK

, COUNT(*) ...

Hi Sean ,

Thank you so much for answering and for your solution, your solution saved me hours and headaches

You were correct, it was a view

Here is the code in...

How can I add a filter to that code ?

I've tried to with this :

where TABLE_NAME = 'v_SEC_NON_SEC_POSN_F_TOTAL'