Skip to content

Query: JB Update Date Status Changed Unallocated

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

Tables Referenced

  • Entrepreneur
  • Entrepreneur Company
  • Entrepreneurs

Columns Selected

  • [Entrepreneurs].[Date Status Changed]
  • \

Where Clause

((([Entrepreneur Company].[Company Status ID])=2) AND (([Entrepreneur Company].[

SQL

SELECT [Entrepreneurs].[Date Status Changed], \ FROM [Entrepreneur Company], [Entrepreneurs] WHERE ((([Entrepreneur Company].[Company Status ID])=2) AND (([Entrepreneur Company].[