Discussion Locked

SQL Query

0 helpful

3 replies

by andres May 2, 2002 last reply May 2, 2002

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How can i build the sql query for checking the duplicate value in the same column and join in a single query?

Example:
ColumnA = Company Name
ColumnB = Employee number

ColumnA has 3 ACME COMPANY record, each one has 67, 89 and 102 employees, the result must be:

ACME COMPANY, 258 employees.

3 replies

Hi,

Here is an example that you should be able to use to solve your problem....

(remove spaces from the above URL)

The site's not too bad in general, too!

Cheers,
Tim.

Poster rated this answer

This question was closed by the author

This discussion is closed to new replies.