Below is our Requirement Lookup file has just one column DatabaseName, this is the left dataset DatabaseName A B C   My Search is for metrics on databases and ha s multiple rows, this is the right dataset DatabaseName Instance CPUUtilization A A1 10 A A2 20 C C1 40 C C2 50 D D 60   Expected Result is this after left join DatabaseName Instance CPUUtilization A A1 10 A A2 20 B NULL NULL C C1 40 C C2 50   But when I join using DatabaseName, I am getting only three records, 1 for A, 1 for B with NULL and 1 for C My background is SQL and for me left join is all from left data set and all matching from right data set. So please suggest me how I can achive this. ... View more