Inner join of two table

Jak
Jak
Member
858 Points
132 Posts

Hi,

I have two table table1 and table2

Table1:

ID1 Name Address
001 xyz address1
002 abc address2

 

Table2:

ID2 ID1 Session
01 001 2013-2014
02 001 2014-2015

 

I want result as:

ID2 Name Session
01 xyz 2013-2014
02 abc 2014-2015
Views: 8580
Total Answered: 1
Total Marked As Answer: 1
Posted On: 01-Nov-2014 07:44

Share:   fb twitter linkedin
Answers
Nice One
Nice One
Member
280 Points
0 Posts
         

Hi,

Use following query:

SELECT
Table2.ID2,Table1.Name,Table2.Session
FROM Table1
INNER JOIN Table2
ON Table1.ID1=Table2.ID1
Posted On: 01-Nov-2014 07:51
 Log In to Chat