Guest User

Untitled

a guest
Jun 18th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. SELECT p.firstname, p.lastname, p.emailaddress
  2. FROM Persons p
  3. WHERE organizationnr IN (
  4. SELECT organization_id
  5. FROM Events
  6. WHERE MONTH(EventDate) = 2 AND YEAR(EventDate) = 2009
  7. )
  8. ORDER BY p.lastname, p.firstname;
  9.  
  10. SELECT organization_id
  11. FROM Events
  12. WHERE MONTH(EventDate) = 2 AND YEAR(EventDate) = 2009
Add Comment
Please, Sign In to add comment