## TL;DR

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.

## Fix

1. ServiceNow uses reference fields (its foreign keys) instead of JOINs.
   Expected: You get the expected result; the problem is gone.

## When to use

- You are setting up or using this ServiceNow feature.
- The symptom matches: how to query fields across two tables without a SQL JOIN.

## When NOT to use

- Unrelated ServiceNow issues (different feature, different failure).
- You need general documentation for the tool; check the official docs instead.

## Compatibility

Reported against ServiceNow.

## Variant phrasings

### how to query fields across two tables without a SQL JOIN

## Why it happens

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

## Edge cases

- If your error message differs even slightly, this is probably a different issue; search the exact text.
- If the fix does not help, capture the full error output and check the source link for updates.