Bugzilla:SQLCookBook: Difference between revisions

Bugzilla:SQLCookBook (view source)

11 bytes added , 26 February 2010

16

edits

@@ Line 14: / Line 14: @@
 ===Get a list of all milestones which belong to a particular classifications===
- select * from milestones where product_id = any (select products.id from products where products.classification_id = 5);
+<pre>
+select * from milestones
+where product_id = any (select products.id from products where products.classification_id = 5);
+</pre>
 -----