ServiceNow uses reference fields (its foreign keys) instead of JOINs. Dot-walk through the reference field, e.g. sys_user.company, to reach fields on the referenced record. You query related-table data by chaining through the reference, not with SQL-style joins.

Context: Stack Overflow question (score 5): a SQL user cannot find how to join two ServiceNow tables in a single query.