> any good suggestions? Dunno if this is right, just woke up, but I'll take a stab at it. Looks like you need another join to the upsell table, then order by its sort by column first.
SELECT brands.brand_id, brands.brand_name, brands.brand_logo, products.product_id, products.brand_id, products.product_item, products.category_id, products.product_image, products. product_archived, products.product_discontinued, upsell.upsell_id, upsell.product_id, upsell.upsell_product_id, upsell.upsell_sort FROM products, brands, upsell WHERE products.brand_id = brands.brand_id AND products.product_id = upsell.product_id AND products.product_id in (20,21) ORDER BY upsell.upsell_sort ASC, brands.brand_name ASC, products.product_item ASC And what's with the... sql help!!!!!!!!!! Sounds like you're goin' down on the titanic! :) Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293711 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
