Skip to content

Instantly share code, notes, and snippets.


mattm/inner.sql Secret

Created November 12, 2018 17:14
What would you like to do?
Implicit vs Explicit INNER
# Good: Specifying INNER
, a.created_at as expressed_interest_at
from helpscout.conversation a
helpscout.conversation_tag b
ON = b.conversation_id
where b.tag = ‘beacon-interest’
# Good: Omitting INNER
SELECT HC.`email`, DATE_FORMAT(HC.`created_at`, '%Y-%m-%e %T UTC') AS expressed_interest_at
FROM `helpscout.conversation` AS HC
JOIN `helpscout.conversation_tag` AS HCT ON HC.`id`=HCT.`conversation_id` WHERE HCT.`tag`='beacon-interest'
ORDER BY expressed_interest_at
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment