What will be the output?

Declare @t1 table(ID1 int)
Declare @t2 table(ID2 int)
Insert into @t1 Values(1),(2),(3),(4),(5)
Insert into @t2 Values(21),(22),(3),(44),(5)

select *
from @t1
MID JOIN @t2 on ID1 = ID2

 Posted by Rajnilari2015 on 11/2/2015 | Category: Sql Server Interview questions | Views: 373 | Points: 40
Select from following answers:
  1. Invalid Keyword MID
  2. Incorrect syntax near keyword JOIN
  3. Common Elements will be joined
  4. It will join only the middle elements
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response