Re: What SQL query ?

Giganews Newsgroups
Subject: Re: What SQL query ?
Posted by:  pietlind…@hotmail.com
Date: 22 Aug 2006

use a summary query and First or Last

SELECT tblCompany.CompanyName, First(Employee.Contact) AS
FirstOfContact
FROM tblCompany INNER JOIN Employee ON tblCompany.CompanyID =
Employee.CompanyID
GROUP BY tblCompany.CompanyName;

Replies

None

In response to

What SQL query ? posted by PL on Tue, 22 Aug 2006