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 ..
>
