Skip to content

Instantly share code, notes, and snippets.

@HenryAtWealthfront
Created May 23, 2023 21:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save HenryAtWealthfront/40d66a63bc185d8f5097d34b2988da12 to your computer and use it in GitHub Desktop.
Save HenryAtWealthfront/40d66a63bc185d8f5097d34b2988da12 to your computer and use it in GitHub Desktop.
SELECT
*
FROM
orders
JOIN
order_allocations
ON orders.id = order_allocations.order_id
WHERE
order_allocations.client_id = 'A'
AND orders.completed_at > date(now())
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment