Skip to content

Query: Qry Get Email Address Owned By

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

Tables Referenced

  • vwGIACompanyList
  • DatabaseUsers

Columns Selected

  • vwGIACompanyList.[Entrepreneur Company ID]
  • OwnedBy
  • DatabaseUsers.[Email Address]

Where Clause

(((vwGIACompanyList.[Entrepreneur Company ID])=[Forms]![Frm Edit Purple Panel Co

SQL

SELECT vwGIACompanyList.[Entrepreneur Company ID], vwGIACompanyList.OwnedBy, DatabaseUsers.[Email Address] FROM [vwGIACompanyList], [DatabaseUsers] WHERE (((vwGIACompanyList.[Entrepreneur Company ID])=[Forms]![Frm Edit Purple Panel Co