I have two tables:
(prod_id, category_id, prod_name, brand, price, status)
(offer_id, prod_id, offer_type, discount_amt, validity)
I want to display products on a page, 20 products at a time.
The problem that I want to display all the products from the
offers table arranged by descending
offer_id and then display products from the
products table except those in the offers table within that 20 limit.
How can I achieve that?