how to insert table join in a form

i tried inserting table join at the sql lookup at one of the fields however it does not work

It would help if you give more details… Like the sql you use and/or a screenshot of your settings…