Sql query inner join with different time setup Hi my problem is that i have 2 different unit of time trying to inner join. how do i solves this?