Skip to content

Query: Qry Lead Type List

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

Tables Referenced

  • IndustryLookup
  • Principal Projects
  • Lead Types
  • Lead
  • Principals

Columns Selected

  • [Lead Types].[Lead Type ID]
  • [Lead Types].[Lead Type]
  • [Lead Types].[Lead Source]
  • [Principal] & \
  • [Lead Types].[Lead Format]
  • Industry
  • [Lead Types].[Import Template]
  • Status

SQL

SELECT [Lead Types].[Lead Type ID], [Lead Types].[Lead Type], [Lead Types].[Lead Source], [Principal] & \, [Lead Types].[Lead Format], IndustryLookup.Industry, [Lead Types].[Import Template], [Lead Types].Status FROM [Lead Types], [IndustryLookup], [Principal Projects], [Principals]