Skip to content

Instantly share code, notes, and snippets.

@HenryAtWealthfront
Created May 23, 2023 21:09
Show Gist options
  • Select an option

  • Save HenryAtWealthfront/40d66a63bc185d8f5097d34b2988da12 to your computer and use it in GitHub Desktop.

Select an option

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