daily pastebin goal
49%
SHARE
TWEET

Untitled

a guest Dec 12th, 2018 68 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT DISTINCT c.name
  2. FROM company.c
  3. INNER JOIN member m
  4. ON m.company_name=c.name
  5. LEFT OUTER JOIN participation p
  6. ON m.first_name=p.first_name AND m.last_name=p.last_name
  7. LEFT OUTER JOIN event e
  8. ON e.event_date=p.event_event_date AND e.name='some-event'
  9. WHERE NOT e.name IS NULL;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top