Skip to content

Instantly share code, notes, and snippets.

@phillipadsmith

phillipadsmith/gist:110183

Created May 11, 2009 20:58
Show Gist options
  • Save phillipadsmith/110183 to your computer and use it in GitHub Desktop.
Save phillipadsmith/110183 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT phillipadsmith_bricbugs.bugs.bug_id,
phillipadsmith_bricbugs.longdescs.bug_id,
phillipadsmith_bricbugs.bugs.bug_status,
phillipadsmith_bricbugs.bugs.short_desc,
phillipadsmith_bricbugs.bugs.bug_severity,
phillipadsmith_bricbugs.longdescs.thetext
FROM phillipadsmith_bricbugs.bugs
INNER JOIN phillipadsmith_bricbugs.longdescs
ON phillipadsmith_bricbugs.bugs.bug_id = phillipadsmith_bricbugs.longdescs.bug_id
WHERE phillipadsmith_bricbugs.bugs.bug_status LIKE '%NEW%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment