Convert all JOINs to LEFTJOIN - SELF JOIN not returning data if one field is empty

Signed-off-by: Dileep Mishra <Dileep.Mishra@kony.com>