>yes that worked but now I don't have any indication of which records came from which table ?

SELECT "LL" AS TableFrom,
    ll_docket AS docket, 
    ll_appearancedate AS appearancedate, 
    ll_judgecode AS judgecode
FROM table1
UNION ALL
SELECT "SC" AS TableFrom,
    sc_docket, sc_appearancedate, sc_judgecode 
FROM table2
UNION ALL
...