I'd dump both tables into temp tables, and cast your time fields as smalldatetime (which doesnt contain the centiseconds) while performing the dump. Join the temp tables.