29.3 JOIN = XLOOKUP / Power Query Merge

By Ravindra Bagale Last updated: 31 October 2026

का (Why). XLOOKUP / Merge दुसऱ्या टेबलचे कॉलम आणतात — SQL मध्ये JOIN.

काय (What). INNER JOIN जुळणारे ठेवतो. LEFT JOIN डावे सर्व ठेवतो (left merge सारखे).

कसं (How). आत्ता कल्पना; सखोल JOIN नंतर — तरी एक छोटा join दाखवा.

पायऱ्या

उदाहरण 1 · dataset: raja_coffee

SELECT o.order_id, c.name, o.city, o.amount_inr
FROM orders AS o
JOIN customers AS c ON c.customer_id = o.customer_id
ORDER BY o.order_id
LIMIT 5;

Output

order_id	name	city	amount_inr
1001	Asha Patil	Pune	840.0
1002	Omar Khan	Mumbai	720.0
1003	Sofia Mendes	Goa	890.0
1004	James Okonkwo	Pune	1050.0
1005	Priya Deshmukh	Kolhapur	620.0

Meaning. प्रत्येक ऑर्डरवर customer नाव lookup.

Ravindra Bagale's Tip

If row counts explode after a join, you have a many-to-many — stop and check keys.