Revision history for QueriesForCommittees


Revision [7550]

Last edited on 2013-01-09 16:26:44 by JasonChow
Additions:
SELECT com.state_id, par.active par_active, par.parent, com.committeetype_id, com.active com_active, com.committee_id, com.child committee, com.url
(SELECT com.active, com.committee_id, com.state_id, com.parent_id, com.name child, com.committeetype_id, com.url
FROM committee com ORDER BY com.active DESC, com.state_id, com.committeetype_id, com.name) com
(SELECT com.active, com.committee_id, com.state_id, com.parent_id, com.name parent, com.committeetype_id, com.url
FROM committee com ORDER BY com.active DESC, com.state_id, com.committeetype_id, com.name) par
Deletions:
SELECT par.active par_active, com.state_id, par.parent, com.committeetype_id, com.active com_active, com.committee_id, com.child committee, com.url
(SELECT com.active, com.committee_id, com.state_id, com.parent_id, com.name child, com.committeetype_id, com.url
FROM committee com ORDER BY com.active DESC, com.state_id, com.committeetype_id, com.name) com
(SELECT com.active, com.committee_id, com.state_id, com.parent_id, com.name parent, com.committeetype_id, com.url
FROM committee com ORDER BY com.active DESC, com.state_id, com.committeetype_id, com.name) par

Revision [7549]

The oldest known version of this page was created on 2013-01-09 16:21:25 by JasonChow
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki