SELECT A.* FROM TableA AS A LEFT JOIN TableB AS B ON A.id = B.table_id WHERE B.table_id IS NULL;

[Meeravali]

How we will achieve this in servicenow, here A table can by table. it is dynamic, i want generate the above query using gliderecord script

[Meeravali]

B has document_id field of A, not reference field