[tam10]

Thanks.

I did.

I get this error.

INVALID SQL: 1054 : Unknown column 'pr.productid' in 'on clause'
SQL QUERY FAILURE:SELECT pr.productid, pr.product, mem.membershipid FROM xcart_products AS pr, xcart_products_categories AS cat LEFT JOIN xcart_product_memberships AS mem ON mem.productid = pr.productid WHERE cat.categoryid = '263' AND pr.productid = cat.productid AND pr.forsale='Y' ORDER BY pr.product

Any idea?