Select tableA.employeeID, count(*)
From tableA
Inner Join tableB
On tableA.employeeID = tableB.employeeID
Group by tableA.employeeID

Assuming that you only have one record in table A for each employee ID I
think this will do what you want

-----Original Message-----
From: Pillai Sreelatha
[mailto:mssqldba-ezmlmshield-x91371212.[Email address protected]
Sent: Friday, February 29, 2008 9:50 AM
To: LazyDBA Discussion
Subject: [SPAM] help with a sql


If i have tableA and tableB both of which are linked with employeeid
column how do i check to see for 1 record of an employee in tableaA
there are multiple records in tableB? Any help will be greatly
appreciated. TIA For reln TableA.employeeid = TableB.employeeid



This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to

which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the

sender by replying to this message and delete this e-mail immediately.



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page