This should show the products in order. Does this help? SELECT * FROM product AS p WHERE p.product_id_map IS NULL UNION SELECT p.* FROM product AS p INNER JOIN product AS p1 ON p1.product_id = p.product_id ORDER BY product_id DESC
Kirk Cerny _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
