WHERE  RE_EZPY_AT_AGENCY_DAILY.MEMBER_NO = VE_MEMBER.MEMBER_NO
AND    (
          (
              RE_EZPY_AT_AGENCY_DAILY.LOCK_USER IS NULL
          OR  RE_EZPY_AT_AGENCY_DAILY.LOCK_USER = :APP_USER
          OR  FOLLOW_UP_DATE <= SYSDATE
          )
          AND RE_EZPY_AT_AGENCY_DAILY.SEND_TO_AGENT IS NULL
       )

quote:

---

Originally posted by angela_g

Hi Can anybody help me with this please? I am trying to add to a query to produce a report in Apex. Currently I have this

SELECT
RE_EZPAY_AT_AGENCY_DAILY.WAITING_TO_BILL AS "WTB",
VE_MEMBER.TITLE,
VE_MEMBER.FIRSTNAME,
VE_MEMBER.SURNAME,
VE_MEMBER.ADDRESS_1,
VE_MEMBER.ADDRESS_2,
VE_MEMBER.ADDRESS_3,
VE_MEMBER.ADDRESS_5,
VE_MEMBER.ADDRESS_4,
VE_MEMBER.POSTCODE,
VE_MEMBER.DAY_PHONE,
VE_MEMBER.NIGHT_PHONE,
VE_MEMBER.MOBILE_PHONE,
VE_MEMBER.MEMBER_JOIN_DATE,
VE_MEMBER.EMAIL_ADDRESS,
RE_EZPY_AT_AGENCY_DAILY.LOCK_USER,
RE_EZPY_AT_AGENCY_DAILY.SEND_TO_AGENT,
RE_EZPY_AT_AGENCY_DAILY.SNAPSHOT_DATE,
RE_EZPY_AT_AGENCY_DAILY.MEMBER_NO_WCD,
RE_EZPY_AT_AGENCY_DAILY.DEBT AS Overdue,
RE_EZPY_AT_AGENCY_DAILY.AGG_ORDER_NO,
RE_EZPY_AT_AGENCY_DAILY.MEMBER_NO,
RE_EZPY_AT_AGENCY_DAILY.STATUS,
RE_EZPY_AT_AGENCY_DAILY.FOLLOW_UP_DATE,
RE_EZPY_AT_AGENCY_DAILY.SENT_TO_AGENT,
RE_EZPY_AT_AGENCY_DAILY.NUMBER_INSTALMENTS,
RE_EZPY_AT_AGENCY_DAILY.AMOUNT_BILLED,
RE_EZPY_AT_AGENCY_DAILY.COMMENTS,
RE_EZPY_AT_AGENCY_DAILY.REVIEW_DATE,
RE_EZPY_AT_AGENCY_DAILY.APP_USER,
RE_EZPY_AT_AGENCY_DAILY.RPT_GROUP,
RE_EZPY_AT_AGENCY_DAILY.CHANGED_TO_AT
FROM RE_EZPY_AT_AGENCY_DAILY,
VE_MEMBER
WHERE RE_EZPY_AT_AGENCY_DAILY.MEMBER_NO = VE_MEMBER.MEMBER_NO
AND ((RE_EZPY_AT_AGENCY_DAILY.LOCK_USER IS NULL
OR RE_EZPY_AT_AGENCY_DAILY.LOCK_USER = :APP_USER)
AND RE_EZPY_AT_AGENCY_DAILY.SEND_TO_AGENT IS NULL)

I want to add 'OR FOLLOW_UP_DATE <= SYSDATE'
How do I add another OR statement?

---