orcale sql related to multi database : select t.FIRST_NAME,t.LAST_NAME,t.GENDER,t.DOB,subj.NAME sub_name,coll.NAME college_name,univ.NAME university_name, dom.name domain,countr.NAME country_name from TEACHER_TB t,SUBJECT_TB subj,COLLG_TCHR_TB ct,COLLEGE_TB coll,UNIVERSITY_TB univ,DOMAIN_TB dom,COUNTRY_TB countr  where t.SUBJECT_ID=subj.SUBJECT_ID and ct.TEACHER_ID=t.TEACHER_ID and coll.COLLEGE_ID=ct.COLLEGE_ID and coll.UNIVERSITY_ID=univ.UNIVERSITY_ID and   dom.DOMAIN_ID=coll.DOMAIN_ID and countr.COUNTRY_ID=univ.COUNTRY_ID 
--------this querry is giving me my data but in that 10 rows i need to pick only those names(name r tecaher name) who r teaching in more than 1 college.so need some help here how to implement for fectchng those 2 names.