forum.venkateswarlu.net
      Register      Login
how to connect more then one tables

2 replies to this topic

Saravanakumar M #1
Member
14 Points
 Posted on 22 Dec 2011 10:45 AM IST how to connect more then one tables 
SQL Server     551 views     Reply to this topic
Suman Battu #2
Member
34 Points
 Replied on 13 Feb 2012 11:09 AM IST U can connect more than one table using Joins , condition

Eg: select * from Emp1 E, mp2 E1

where E.id = E1.Id

Eg: ---Joins---

Select * from Emp1 E1 inner Join Emp2 E2
on E1.Id= E2.Id
where Condition

these r sample i hope this will help u

 
Reply to this topic
Subramaniam R #3
Member
152 Points
 Replied on 05 Aug 2013 02:34 PM IST Using Join condition you connect more than one tables as well as UNION also 
Reply to this topic