I would go with Jamies suggestions, the only thing I dont understand (not about jamies post) is what the hell is a full join, left, right, inner, outer never heard of a full join.
Anyway just use Jamie's sample and you will be on to a winner. Thanks Sean On Jan 25, 11:40 am, Jamie Fraser <[email protected]> wrote: > SELECT > * > FROM > Collegedetails C > INNER JOIN > Traininginstitute T ON C.inst_name = T.inst_name > > Replacing INNER with LEFT/OUTER/ETC > > > > On Fri, Jan 22, 2010 at 10:08 AM, 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 ..- Hide quoted text - > > - Show quoted text -
