Yeah... heard of JOIN's ?
On Jan 22, 3:08 pm, Sruthi <[email protected]> wrote: > Hi, > > i am facing a problem while selecting data from multiple tables.. > > Actually i need to select data from three tables.. > > While retrieving am getting the repetition of datas where the > resultant is a multiple of the three tables > > select c.*,t.* FROM [collegedetails] c, [traininginstitute] t where > c.inst_name=t.inst_name > > this is my query... > > any suggestions plzzzz. > > thanks in advance ..
