Skip to content

Query: Jo Qry Uncontacted Followup Ready for Allocation

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

Tables Referenced

  • Entrepreneurs
  • Jo Qry Uncontacted Unfollow Reeady for Allocation
  • Jo

Columns Selected

  • [Jo Qry Uncontacted Unfollow Reeady for Allocation].[Lead Type]
  • Entrepreneurs.[First Name]
  • Surname
  • [Jo Qry Uncontacted Unfollow Reeady for Allocation].[Email Address]
  • Race
  • Entrepreneurs.[Identity Number]
  • Gender
  • Entrepreneurs.[Telephone Number]
  • Entrepreneurs.[Delivery Location ID]
  • Entrepreneurs.[Entrepreneur Company ID]
  • [Jo Qry Uncontacted Unfollow Reeady for Allocation].[Information 4]
  • [Jo Qry Uncontacted Unfollow Reeady for Allocation].[Process Status ID]

SQL

SELECT [Jo Qry Uncontacted Unfollow Reeady for Allocation].[Lead Type], Entrepreneurs.[First Name], Entrepreneurs.Surname, [Jo Qry Uncontacted Unfollow Reeady for Allocation].[Email Address], Entrepreneurs.Race, Entrepreneurs.[Identity Number], Entrepreneurs.Gender, Entrepreneurs.[Telephone Number], Entrepreneurs.[Delivery Location ID], Entrepreneurs.[Entrepreneur Company ID], [Jo Qry Uncontacted Unfollow Reeady for Allocation].[Information 4], [Jo Qry Uncontacted Unfollow Reeady for Allocation].[Process Status ID] FROM [Jo Qry Uncontacted Unfollow Reeady for Allocation], [Entrepreneurs]