Hi from Spain,
well... what you want to retrieve? I need to know the database structure and the data you want. Your query only uses two tables. i.e. Watching your query, perhaps you want that: select c.*, t* from collegedetails c inner join traininginstitute t on c.inst_name = t.inst_name You can find help searching info about: inner join, left join, right join, full join. On 22 ene, 11:08, 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 ..
