Bugzilla:SQLCookBook: Difference between revisions

Jump to navigation Jump to search
Line 14: Line 14:


===Get a list of all milestones which belong to a particular classifications===
===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>


-----
-----
16

edits

Navigation menu