If we write below query,then what will happen?

select * from employee_master join project_master;
//OR
select * from employee_master inner join project_master;

 Posted by vishalneeraj-24503 on 11/28/2013 | Category: Sql Server Interview questions | Views: 3918 | Points: 40
Select from following answers:
  1. Command(s) completed successfully.
  2. Produce an result matching both table record(s).
  3. Msg 102, Level 15, State 1, Line 1 Incorrect syntax near ';'.
  4. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response