Skip to content

Query: Qry Export Certificate Mail Merge Information

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

Tables Referenced

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

Columns Selected

  • [Temp Entrepreneur ID for Contract Mail Merge].[Entrepreneur Company ID]
  • [Temp Entrepreneur ID for Contract Mail Merge].[Entrepreneur Company Programme Y
  • vwGarnetExportCompanyInformationforCertificateMailMerge.[Company Name]
  • vwGarnetExportCompanyInformationforCertificateMailMerge.[Entrepreneur ID]
  • [First Name] & \
  • vwGarnetExportCompanyInformationforCertificateMailMerge.[Delivery Location]
  • vwGarnetExportCompanyInformationforCertificateMailMerge.[Date Status Changed]
  • vwGarnetExportCompanyInformationforCertificateMailMerge.[Programme Year]
  • vwGarnetExportCompanyInformationforCertificateMailMerge.[Certificate Programme N
  • [Product Code] & \
  • Principal

Order By

[Temp Entrepreneur ID for Contract Mail Merge].[Entrepreneur Company Programme Y, vwGarnetExportCompanyInformationforCertificateMailMerge.[Entrepreneur ID], vwGarnetExportCompanyInformationforCertificateMailMerge.Principal

SQL

SELECT [Temp Entrepreneur ID for Contract Mail Merge].[Entrepreneur Company ID], [Temp Entrepreneur ID for Contract Mail Merge].[Entrepreneur Company Programme Y, vwGarnetExportCompanyInformationforCertificateMailMerge.[Company Name], vwGarnetExportCompanyInformationforCertificateMailMerge.[Entrepreneur ID], [First Name] & \, vwGarnetExportCompanyInformationforCertificateMailMerge.[Delivery Location], vwGarnetExportCompanyInformationforCertificateMailMerge.[Date Status Changed], vwGarnetExportCompanyInformationforCertificateMailMerge.[Programme Year], vwGarnetExportCompanyInformationforCertificateMailMerge.[Certificate Programme N, [Product Code] & \, vwGarnetExportCompanyInformationforCertificateMailMerge.Principal FROM [Temp Entrepreneur ID for Contract Mail Merge], [vwGarnetExportCompanyInformationforCertificateMailMerge]