Skip to content

Query: Qry Export Contract Mail Merge Information

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

Tables Referenced

  • vwGarnetExportEntrepreneurInformationforContractMailMerge
  • Temp Entrepreneur ID for Contract Mail Merge
  • Temp

Columns Selected

  • vwGarnetExportEntrepreneurInformationforContractMailMerge.[Entrepreneur ID]
  • vwGarnetExportEntrepreneurInformationforContractMailMerge.[Email Address]
  • [Temp Entrepreneur ID for Contract Mail Merge].[Entrepreneur Company ID]
  • vwGarnetExportEntrepreneurInformationforContractMailMerge.[Entrepreneur Company
  • [Project Name] & \
  • vwGarnetExportEntrepreneurInformationforContractMailMerge.[Contract Printed]
  • vwGarnetExportEntrepreneurInformationforContractMailMerge.[Allocated Amount]
  • Format([Contract Start Date],\
  • vwGarnetExportEntrepreneurInformationforContractMailMerge.[Contract Start Date]

SQL

SELECT vwGarnetExportEntrepreneurInformationforContractMailMerge.[Entrepreneur ID], vwGarnetExportEntrepreneurInformationforContractMailMerge.[Email Address], [Temp Entrepreneur ID for Contract Mail Merge].[Entrepreneur Company ID], vwGarnetExportEntrepreneurInformationforContractMailMerge.[Entrepreneur Company , [Project Name] & \, vwGarnetExportEntrepreneurInformationforContractMailMerge.[Contract Printed], vwGarnetExportEntrepreneurInformationforContractMailMerge.[Allocated Amount], Format([Contract Start Date],\, vwGarnetExportEntrepreneurInformationforContractMailMerge.[Contract Start Date] FROM [Temp Entrepreneur ID for Contract Mail Merge], [vwGarnetExportEntrepreneurInformationforContractMailMerge]