Skip to content

Instantly share code, notes, and snippets.

@HenryAtWealthfront
Created May 23, 2023 21:12
Show Gist options
  • Save HenryAtWealthfront/edd4aefbe841b78ff9945a321879b230 to your computer and use it in GitHub Desktop.
Save HenryAtWealthfront/edd4aefbe841b78ff9945a321879b230 to your computer and use it in GitHub Desktop.
SELECT
*
FROM
orders
JOIN
order_allocations
ON orders.id = order_allocations.order_id
WHERE
orders.completed_at > date(now())
AND order_allocations.client_id = 'A'
AND order_allocations.order_id > :yesterdaysId
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment