update query with inner join roundup

[tmcrouse]

I have two tables and I want to do an update query with an inner join to the other but when I update I want to roundup because the datatype in 1 table is (18,2) and the other decimal(18,4). For example in the table that is 18,4, the rate is 0.7982 and when I do an update query to the table that has 18,2, it makes the rate 79.



I have tried an update query below but not sure how to incorporate the roundup portion

UPDATE table1 INNER JOIN table2 on table1.lob = table2.lob and table1.product = table2.product and table1.state = table2.state 
SET table1.rate = table2.rate
where table1.vendor = "JBS";

[JoeM]

Try:

UPDATE table1 INNER JOIN table2 on table1.lob = table2.lob and table1.product = table2.product and table1.state = table2.state 
SET table1.rate = Round(table2.rate,2)
where table1.vendor = "JBS";

[tmcrouse]

Thats the ticket thanks