learnkdb
DocsQuestionsMock Interview⚡ Rapid Quiz
Sign inBook an interview

Getting Started

  • Getting Started with kdb+/q

Core Concepts

  • Types
  • q Terminology
  • Operations on Lists (Iterators & Amend)
  • Dictionaries
  • In Memory Tables
  • Functions
  • Attributes
  • Iterators
  • Interprocess Communication (IPC)
  • Memory Management & Memory Mapping
  • Persisting Tables

Data Analysis

  • qSQL
  • Joins
    Each-Left JoinPractice Questions (1)
    Join (,) and Union Join (uj)
    Join-Each (,')
    Left-Join (lj), Inner-Join (ij), Plus-Join (pj)
    Window Join (wj)
    Asof
    As-of Join (aj)

System Features

  • File Parsing
  • Serialization
Back to Joins

Joins

Each-Left Join

Skip to 1 practice question

Practice questions on extending a table with each-left (\:), pairing a fixed right-hand value against every row.

Practice Questions

Test your understanding with 1 hands-on question

01Extend a Table with New Null Columns
JL

Ready to test yourself?

Book a 60-minute mock kdb+/q interview with Jeremy Lucid, with feedback on what to work on next.

Book an interview
PreviousJoinsNextJoin (,) and Union Join (uj)
learnkdb

Free, step-by-step kdb+/q learning material, from core data structures to qSQL, joins and IPC.

Content

  • Documentation
  • Practice Questions
  • Rapid Quiz

Mock interviews

  • Book an interview
  • Contact & terms
  • Privacy
  • Jeremy Lucid on LinkedIn

Account

  • Sign in
  • Dashboard

© 2026 learnkdb.com. All rights reserved.

kdb+ and q are trademarks of Kx Systems, Inc.