There are several libraries and table, such as
A library num1 table, b library num2 table, c library num3 table, there is a common value cid

How to query, a.n um1 in order, isn't it did not appear in library num2 table b and c library num3 list?