count with having greater than 1

[kernal]

I have 2 tables:

2 Tables:

table 1

ID SUBJECT CRSE_NUMBER SECTION
1 TEST 500 1
1 PRP 600 3

2 TEST 100 1

3 PRP 200 4
3 BT 500 1
3 SD 200 5

Joined with table 2 on subject

SUBJECT ORG

TEST TEST
PRP PRP
BT BTL
SD SDY

I need to find all IDs that have more then 1 ORG so it would retrieve

ID SUBJECT CRSE_NUMBER SECTION
1 TEST 500 1
1 PRP 600 3

3 PRP 3200 4
3 BT 4500 1
3 SD 4200 5

Help is appreciated!

 

[Axoliien]

Uses exists and a subselect with a group by.