🔥 3-day streak
Microsoft Fabric Analytics Engineer Associate128 / 150
Question 128 of 150

You are building a reconciliation report in a Fabric warehouse. Table SalesLedger and table PaymentsLedger both contain a TransactionId column. You need a single result set that returns every TransactionId from both tables — including transactions that appear only in SalesLedger, only in PaymentsLedger, and in both — so that missing entries on either side become visible. Which T-SQL join should you use?

Reviewed for accuracy · Report an issueNext question