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

Reply via email to