Skip to content

Instantly share code, notes, and snippets.

@ofelix03

ofelix03/cross-referencing-raising-error.sql

Created October 28, 2022 18:00
Show Gist options
  • Save ofelix03/69c8661bf6928d4efbe685a56c4b488e to your computer and use it in GitHub Desktop.
Save ofelix03/69c8661bf6928d4efbe685a56c4b488e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cross-referencing-raising-error.sql
SELECT name, email, s.ip_addresses
FROM users u
LEFT JOIN (
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