Sean, a FULL OUTER JOIN is a rather unusual join which returns all the data from both tables, even if it doesn't always match. I haven't ever had to use one IIRC!
On Tue, Jan 26, 2010 at 12:18 AM, SeanJC <[email protected]> wrote: > 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 - >
