Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Cyclonik
Posting Yak Master
114 Posts |
 Posted - 2001-02-13 : 19:23:49
|
| ( select b.lanid,b.Fname,b.Lname, count(a.agent)as Total from tblUsersT b left JOIN tblVoice_monitorsT a ON b.lanid=a.agent Where b.managerid = 'bowens' group by b.Lname,b.Fname,b.lanid ) what i need from this query is only the COUNT of the records in table "A" where the manager ID is equal to b.manageridIf i add "and where a.managerid = 'bowens'" it only returns the the records where the "lanid" mathces in both tables killing my Left Join.without the added where condition i get a COUNT of every record for that person no matter what the managerid is in table "A"Maybe i am just missing something..hope this doesn't sound too confusingThanks Christian-=:SpasmatiK:=- |
|
|
|
|
|
Query problem..