Skip to content

Instantly share code, notes, and snippets.

@ofelix03

ofelix03/cross-referencing-with-lateral-keyword.sql

Last active October 28, 2022 18:26
Show Gist options
  • Save ofelix03/f73177e2c348c3cbe5825e58322ec6d4 to your computer and use it in GitHub Desktop.
Save ofelix03/f73177e2c348c3cbe5825e58322ec6d4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cross-referencing-with-lateral-keyword.sql
SELECT name, email, s.ip_addresses
FROM users u
LEFT JOIN LATERAL (
SELECT user_id, string_agg(ip_address, ',') "ip_addresses"
FROM site_visits
WHERE country in ('China')
and user_id = u.id
GROUP BY user_id
) s
ON u.id = s.user_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment