SQL

#1
BeniHorvat

Posted 23 January 2017 - 12:22

New Member

Grup: Junior Members
Posts: 6
Înscris: 23.01.2017

Buna, poate cineva sa ma ajute cu urmatoarea chestie.

am 4 tabele:

aici se gasesc toti userii
USER
id_user
nume

USER1                    GRUP_USER         GRUP
id_user1                  id_grup                  id_grup
                                id_user                  nume

trebuie sa selectez un grup doar daca toti userii care sunt in acel grup se gasesc in tabela USER1.

Back to top

#2
Orange09

Posted 23 January 2017 - 12:32

Active Member

Grup: Members
Posts: 1,415
Înscris: 16.06.2014

Vezi cum se foloseste IN sau EXIST

Edited by Orange09, 23 January 2017 - 12:32.

Back to top

#3
_Smiley_

Posted 23 January 2017 - 12:39

Guru Member

Grup: Senior Members
Posts: 20,032
Înscris: 24.02.2006

select *
from Group g
where not exist
(select 1 from GRUP_USER gu
where gu.id_grup = g.id_grup
and id_user not in (select id_user1 from USER1))

cred ca mai trebuie sa verifici cazul grupurilor care nu au nici un user

Back to top

#4
BeniHorvat

Posted 23 January 2017 - 13:28

New Member

Grup: Junior Members
Posts: 6
Înscris: 23.01.2017

_Smiley_, on 23 ianuarie 2017 - 12:39, said:

select *
from Group g
where not exist
(select 1 from GRUP_USER gu
where gu.id_grup = g.id_grup
and id_user not in (select id_user1 from USER1))

cred ca mai trebuie sa verifici cazul grupurilor care nu au nici un user

Mersi!

Back to top

Anunturi

Bun venit pe Forumul Softpedia!

#1 BeniHorvat Posted 23 January 2017 - 12:22

#2 Orange09 Posted 23 January 2017 - 12:32

#3 _Smiley_ Posted 23 January 2017 - 12:39

#4 BeniHorvat Posted 23 January 2017 - 13:28

Anunturi

▶ 0 user(s) are reading this topic

Sign In

#1
BeniHorvat

Posted 23 January 2017 - 12:22

#2
Orange09

Posted 23 January 2017 - 12:32

#3
_Smiley_

Posted 23 January 2017 - 12:39

#4
BeniHorvat

Posted 23 January 2017 - 13:28