Re: SQL Query

Something like this:

SELECT
PhoneNumber
, Occurences = count( PhoneNumber )
FROM TableA a
JOIN TableB b
ON a.PhoneNumber = b.PhoneNumber
GROUP BY PhoneNumber
HAVING count( PhoneNumber ) > 1

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"murtaza" <murtaza74@xxxxxxxxx> wrote in message news:8C121C0B-A673-485A-AD31-857E532F57EC@xxxxxxxxxxxxxxxx
Dear all,

i've one table (A) which has one field with uniqure phone number recrods,
and there is another table (B) which includes misc. numbers plus records from
table A.

my query is that i want to knwo that which number from table A and how many
times it has been inserted in table B.

can some body help me with that