Hello -
Need some assistance, please....
I'm trying to use a nested select query to determine if an active MemberID that is in the "original" table is NOT in the secondary table. Table is data of member info and clinical notes. I need and only want any member # that is active but does
NOT have a clinical note entered within the past year. I have all the clinical note dates, clinical note ID's, since when the database was created (12+ year ago)
The original table (table 1) is populated with member ID #'s from the onset of the database, and the secondary table (table 2) is populated with all members which have a clinical note dated within the past year.
I create the secondary table (table 2) and populate it as a temp table.
Hope this is enough info to get started.....
Am stuck on the nested select statement along the lines of:
Select name
from table1
where status = 'active' Go to the complete details ...