support native join for denormalization