Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT p.firstname, p.lastname, p.emailaddress
- FROM Persons p
- WHERE organizationnr IN (
- SELECT organization_id
- FROM Events
- WHERE MONTH(EventDate) = 2 AND YEAR(EventDate) = 2009
- )
- ORDER BY p.lastname, p.firstname;
- SELECT organization_id
- FROM Events
- WHERE MONTH(EventDate) = 2 AND YEAR(EventDate) = 2009
Add Comment
Please, Sign In to add comment