What is the difference between regular join and database join ?

We can execute a prepared sql join statement directly in the database join step whereas we cannot do that in the regular join