After updating reports from SQL6.5 to SQL7.0, now have to use fully qualified tablename to get reports that include SQL Selection Criteria to work. In this example had to add prodPHS.dbo.apptwl whereas previously alias apptwl worked okay. Any thoughts ?
( apptwl2.waitlist_id = (select min(apptwl3.waitlist_id)
from prodPHS.dbo.apptwl apptwl3
where apptwl3.appt_id = apptwl2.appt_id
and apptwl3.list_add_datetime is not null
and apptwl3.wlprior_id not in (1,16)))
( apptwl2.waitlist_id = (select min(apptwl3.waitlist_id)
from prodPHS.dbo.apptwl apptwl3
where apptwl3.appt_id = apptwl2.appt_id
and apptwl3.list_add_datetime is not null
and apptwl3.wlprior_id not in (1,16)))