When i do it... it takes all values from left table and only those values from right table where id and date is matching.