On 6/20/2012 9:27 AM, Merrill Oveson wrote: > People smarter than me: > > Suppose I have the following table: > > product_id | product | product_id_map > 30 | X | NULL > 29 | A | 30 > 28 | W | 29 > > > so product 28 "maps" to product 29 and product 29 "maps" to product > 30. Product 30 is the beginning. > > The view I want would look like this: > > product_id | product > 30 | X > 29 | A > 28 | W > > Possible to create a view using cursors to do this? Or is there an easier > way? > > _______________________________________________ > > UPHPU mailing list > [email protected] > http://uphpu.org/mailman/listinfo/uphpu > IRC: #uphpu on irc.freenode.net
Here is a link that might help. http://stackoverflow.com/questions/1085287/hierarchical-data-in-mysql _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
