Skip to content

Instantly share code, notes, and snippets.

@dustinchilson

dustinchilson/gist:826378

Created February 14, 2011 19:16
Show Gist options
  • Save dustinchilson/826378 to your computer and use it in GitHub Desktop.
Save dustinchilson/826378 to your computer and use it in GitHub Desktop.
Download ZIP
multi-level query
Raw
gistfile1.sql
SELECT
`Classe`.`id`,
`Classe`.`desc`,
`superClass`.`id`,
`superClass`.`desc`,
`superSuperClass`.`id`,
`superSuperClass`.`desc`
FROM `classes` AS `Classe`
LEFT JOIN `classes` AS `superClass`
ON (`Classe`.`parent_id` = `superClass`.`id`)
LEFT JOIN `classes` AS `superSuperClass`
ON (`superClass`.`parent_id` = `superSuperClass`.`id`)
WHERE `Classe`.`id` = '10021792'
LIMIT 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment