PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
I guess the reason is because the Notestbl is very large (over 1.5 Mil rec.).
Select * from view_frmOrientationSchedule where exists (Select 1 from dbo.NotesTbl INNER JOIN dbo.View_EmployeesLastNoteID ON dbo.NotesTbl.ID = dbo.View_EmployeesLastNoteID.LastID Where NotesTbl.EmployeeID = view_frmOrientationSchedule.EmployeeID and Date >= '02/01/15')
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|MS Access 2013 - Multi-selection of records conforming to multiple criteria in different uncontrolled fields||5||31|
|CASE Statement using different fields||8||31|
|Ranking Students in a normalised Ms Access Database (Ms Access 2010)||7||64|
|Access 2003, find all instances of database ODBC||3||49|
Join the community of 500,000 technology professionals and ask your questions.