Code is working good if data greater than target date (>) is selected :

SELECT        

xyz.ID,

xyz.Gender,

xyz.geography,

xyz.code,

xyz.delivery_status,

abc.department_code

FROM v.table1 as xyz

left join y.table2 as abc

on

xyz.ID = abc.ID AND 

xyz.code = abc.code

where xyz.partition_date < '2021-01-01' 

group by 1,2,3,4,5,6

-- It's working when using xyz.partition_date >= 2020-01-31 

@Aman Sehgal​  @Stephan Lawson​  @Darryll Petrancuri​  @sql-thetan​