sql - How to extract table name from query on SPARKSQL

Question

SELECT a.*
FROM schema.table1 a
LEFT JOIN ( 
    SELECT a*
    FROM schema.table1 a
    JOIN schema.table2 b 
    ON a.col1 = b.col1
    WHERE a.col1= <[Parameters].[Parameter 2]>
        AND b.col1>= 3
    UNION
        SELECT a*
    FROM schema.table3 a
    JOIN schema.table4 b 
    ON a.col1 = b.col1
    WHERE a.col1= <[Parameters].[Parameter 2]>
        AND b.col1>= 3
) comp ON a.col1= comp.col1

from this I want to extract schema.table1,schema.table2,schema.table3,schema.table4 what would be my query

question from:https://stackoverflow.com/questions/65882431/how-to-extract-table-name-from-query-on-sparksql

Answer 1

Waitting for answers