How do you get the result set from two tables in glide script in Servicenow?

Question

Q:

How do you get the result set from two tables in glide script in Servicenow?

Answer 1

addJoinQuery(joinTable, [primaryField], [joinTableField])
Note : This is not a true DATABASE Join. addJoinQuery() adds a subQuery.