Skip to content

Query: SubQry Get Moved Last Week to Active PP Allocated Exited

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

  • vwPurpleGetMovedLastWeektoActivePPAllocatedExited

Columns Selected

  • vwPurpleGetMovedLastWeektoActivePPAllocatedExited.[Entrepreneur Company ID]

Where Clause

(((vwPurpleGetMovedLastWeektoActivePPAllocatedExited.[Date Status Changed])>=Dat

Order By

vwPurpleGetMovedLastWeektoActivePPAllocatedExited.[Entrepreneur Company ID]

SQL

SELECT vwPurpleGetMovedLastWeektoActivePPAllocatedExited.[Entrepreneur Company ID] FROM [vwPurpleGetMovedLastWeektoActivePPAllocatedExited] WHERE (((vwPurpleGetMovedLastWeektoActivePPAllocatedExited.[Date Status Changed])>=Dat