Hi,
Please help me to form a criteria for this query
UPDATE tickets
SET seller_cobrand = :arg1
WHERE id IN (SELECT T.id FROM tickets T, events E
WHERE
T.event_id = E.id AND
E.event_date > SYSDATE AND
T.SELLER_ID = :arg2 AND
T.quantity_remain > 0 AND
T.end_date > SYSDATE AND
T.system_status IN ('ACTIVE','INACTIVE'))
Please help me to form a criteria for this query
UPDATE tickets
SET seller_cobrand = :arg1
WHERE id IN (SELECT T.id FROM tickets T, events E
WHERE
T.event_id = E.id AND
E.event_date > SYSDATE AND
T.SELLER_ID = :arg2 AND
T.quantity_remain > 0 AND
T.end_date > SYSDATE AND
T.system_status IN ('ACTIVE','INACTIVE'))