Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

count with having greater than 1

Status
Not open for further replies.

kernal

Technical User
Feb 27, 2001
415
US
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top