[John7]

INVALID SQL: 1109 : Unknown table 'table_name' in order clause
SQL QUERY FAILURE: select DISTINCT xcart_products.*, xcart_categories.category, xcart_pricing.price from xcart_products, xcart_pricing, xcart_categories, xcart_product_links where (xcart_pricing.membership='') and (xcart_pricing.productid=xcart_products.productid) and (xcart_pricing.quantity=1) and (xcart_products.categoryid=xcart_categories.catego ryid) and xcart_products.forsale='Y' and (xcart_products.productid=xcart_product_links.prod uctid2) and (xcart_product_links.productid1='2') ORDER BY table_name.field_name




Here is what happens when I do that