joined:Sept 24, 2009
Hello all, I need some help with this query.. The query is very long so I'm not posting it here unless it'll really be necessary. Basically it gets some rows from table products by some terms and Left JOINs other tables checking some stuff there. Now I need the following: There are dates when those products are reserved so I need to exclude those from the result based on provided date range something like
SELECT FROM #__properties_available_product'
.' WHERE id_product = ' .$prop_id
.' AND date BETWEEN "'.$start.'" AND "' .$end. '"'; But to exclude those from the result.