Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select ks.lekime || '-' || ks.sostav as LEKOVI from lek ks where
- ks.lekid in
- (
- select lekid from
- (
- select count(r.lekid),r.lekid from lek l,recept r
- where l.lekid = r.lekid
- group by r.lekid
- having count(r.lekid) < 3
- ) a
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement