I have a table contains fields name, year,month,day and another table contains name, year,month
I wanna left join these two tables
How i can do that(i don't have a field day in second table and it causes repeating data )?
i would appreciate if someone can help
example of my tables
accident price repeat 2 times because we have 2 rows in table 1
what can i do to solve this problem?
Yes it will repeat in this case, But there should be another key field in your data that identifies or mapped with your field 'accident price' that shows different value for each line of record and that will remove your repeating data.
You can add that field to remove duplication.