After a discussion with a friend, I came across an interesting article about the modern SQL in PostgreSQL (sorry the article is in czech). What raised my attention was a mention about the Lateral join . I work mostly on Db2 for z/OS and haven't heard the term in this context. What about you? ...