-1

I have the following dataset

Table A                   Table B

Name     Age              Name      Eye Color
Ashish   24               Ashish    Brown 
Max      16               George    Black
Rehan    12               Tim       White
Tim      16               Sadhana   Blue 
maggie   25               Ashsih    Brown 
martha   27               Ashish    Black

Now i need to understand for the record Ashish , how many rows will be created in the resulting table. if i am performing left join between Table A and Table B , where Table A is on the Left Side and B on right.

Always_Learning
  • 33
  • 5
  • 3
    Why don't you try it first? – Raging Bull Aug 12 '15 at 07:59
  • 1
    possible duplicate of [Left join and Left outer join in SQL Server](http://stackoverflow.com/questions/406294/left-join-and-left-outer-join-in-sql-server) – Paddy Aug 12 '15 at 07:59
  • Are you really going to join using names? Aren't there any foreign key – huMpty duMpty Aug 12 '15 at 08:02
  • I just need to understand how does the left join works , I know all the rows from the Left table will be displayed and the matching one from right will be displayed . I just need to have a picture of the resulting table by applying left join because "Ashish" has duplicate entries. – Always_Learning Aug 12 '15 at 08:02
  • http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins – Maciej Los Aug 12 '15 at 08:04

1 Answers1

1

As the table B has three rows for that value, you will have three rows returned when using a LEFT JOIN

Madhivanan
  • 13,470
  • 1
  • 24
  • 29