Skip to content

Instantly share code, notes, and snippets.

@robertpfeiffer

robertpfeiffer/gist:135093

Created June 24, 2009 08:30
Show Gist options
  • Save robertpfeiffer/135093 to your computer and use it in GitHub Desktop.
Save robertpfeiffer/135093 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
CREATE VIEW actormw AS SELECT DISTINCT * FROM ((SELECT NAME, ‚w’ AS SEX, MOVIE_ID, ROLE FROM „actress“) UNION ALL (SELECT NAME, ‚m’ AS SEX, MOVIE_ID, ROLE FROM actor));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment