Tuesday, January 17, 2012

Please guys help me out to solve this below described oracle query..?

i have two tables 1)Bgroup table and 2)Contact table where the "id no." is primary key in Bgroup table and foreign key in contact table. my problem is i want to display name,bldgroug, and contact no merging these two tables i am able to display it but its showing name and bldgroup repeated results as one person will be having more than one contact no. so i want to display the name,bldgroup only once and followed by all the contact no.s of tat person. I hav used distinct key word but no use plz help me out... Bgroup table contains ID pk,Name,Bldgroup and Contact table contains ID fk,contact no.

0 comments:

Post a Comment