YES!! it work! thank you very much.
Here you are for those who need sql simple join query for dynamic select field.
example: get current article author email with dynamic select field
Table : #__content,#__users
Where: #__content.created_by=#__users.id AND #__content.id=$uri->get('id')
Option Value: email
Limit: 1