Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select Obj.regcode,count(*)
- FROM dbo.Objecten Obj
- INNER JOIN dbo.Dossiers Dos ON obj.objectnr=Dos.objectnr
- WHERE Dos.plan_gereed between '2014-01-01' and '2014-02-01'
- group by obj.regcode having count(*) > 1
- SELECT obj.regcode, Dos.dossiernr
- FROM dbo.objecten obj,
- dbo.Dossiers Dos
- WHERE obj.regcode IN ( select Obj.regcode,count(*)
- FROM dbo.Objecten Obj
- INNER JOIN dbo.Dossiers Dos ON obj.objectnr=Dos.objectnr
- WHERE Dos.plan_gereed between '2014-01-01' and '2014-02-01'
- group by obj.regcode
- having count(*) > 1 )
- AND obj.objectnr=Dos.objectnr
- SELECT obj.regcode, Dos.dossiernr FROM dbo.objecten obj, dbo.Dossiers Dos WHERE obj.regcode IN ( select Obj.regcode FROM dbo.Objecten Obj INNER JOIN dbo.Dossiers Dos ON obj.objectnr=Dos.objectnr WHERE
- Dos.plan_gereed between '2014-01-01' and '2014-02-01' group by obj.regcode having count(*) > 1 ) AND obj.objectnr=Dos.objectnr
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement