>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
UNIONALLSELECT"SC"AS TableFrom,
sc_docket, sc_appearancedate, sc_judgecode
FROM table2
UNIONALL
...