Database

Employer
--------
IdEmployer
Name

CustomerEmployer
----------------
IdEmployer
IdCustomer

Customer
--------
IdCustomer
{other columns}

papa80 wrote:

SO my question is please give me query who give it to me employer.name with max customet how to do that???

SELECT Employer.Name
FROM Employer
INNER JOIN CustomerEmployer ON CustomerEmployer.IdEmployer = Employer.IdEmployer
WHERE IdCustomer = (SELECT MAX(IdCustomer) FROM CustomerEmployer)

SELECT Employer.Name, CustomerCount.NumCustomers
FROM Employer
INNER JOIN (SELECT IdEmployer, COUNT(*) AS NumCustomers
            FROM CustomerEmployer) AS CustomerCount
ON CustomerCount.IdEmployer = Employer.IdEmployer

Colin Angus Mackay wrote:

SELECT Employer.Name, CustomerCount.NumCustomersFROM EmployerINNER JOIN (SELECT IdEmployer, COUNT(*) AS NumCustomers FROM CustomerEmployer) AS CustomerCountON CustomerCount.IdEmployer = Employer.IdEmployer

Select CCY, EX_RATE, MIN(RATE_DT) as START_DT, MAX(RATE_DT) as END_DT
From your_currency_table
Group by CCY, EX_RATE

CCY  EX_RATE  RATE_DT
---- ------- -------
AED   1.1    7/31/06
AED   1.0    6/30/06
AED   1.5    5/31/06

CCY  EX_RATE START_DT  END_DT
---- ------- -------   ------
AED   1.1    7/31/06   7/31/06
AED   1.0    6/30/06   6/30/06
AED   1.5    5/31/06   5/31/06

CCY   EX_RATE START_DT END_DT
---- ------- -------- ------
AED   1.1     7/31/06 (NULL)
AED   1.0     6/30/06 7/31/06
AED   1.5     5/31/06 6/30/06

CString str;
str.Format("SELECT * INTO [Excel 8.0;DATABASE=%s].[%s] FROM [%s]", ExcelFile, Worksheet, Table);

// pConn is a database connection

pConn->Execute(str.AllocSysString(), NULL, adExecuteNoRecords);