how to join four table using select statement dynamics ax

i have four tables … i need to join four table … Based on the value in the first table that value should be updated automatically

in the fourth table.

Your title talks about a select statement, but then you want to value updates. It doesn’t seems to fit together. Please try to explain again what you’re trying to achieve.