| 'where' condition... [message #371975] |
Fri, 29 December 2000 00:03  |
xingxing3
Messages: 2
Registered: December 2000
|
Junior Member |
|
|
EXEC this sql and recieve ERROR Msg. pls look it and find some mistake.. thanks a lot!
------
select a.ID, a.Unit, count(a.Serial)
from Table_1 a
where (select count(c.Serial)
from Table_2 c
where a.Serial=c.Serial) >1
group by a.ID, a.Unit
|
|
|
|
| Re: 'where' condition... [message #371978 is a reply to message #371975] |
Fri, 29 December 2000 09:14  |
me
Messages: 66
Registered: August 2000
|
Member |
|
|
select a.ID, a.Unit, count(a.Serial)
from Table_1 a,
Table_2 c
where a.Serial=c.Serial
group by a.ID, a.Unit
having count(a.Serial) > 1
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
