left join

[Anonymous]

Hello everyone

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

[nitin_01]

Yes I can see that.

I would suggest to find the key field that gives you different value for each record of line for 'accident price' and put it in your table or else values will be repeating.

Regards,

Nitin.

[Gysbert_Wassenaar]

Make a choice. To which day should to accident price be joined? Or should it be distributed over the days of the month? What is the result you expect?